Case sensitivity problem in a join

[kherm]

Access cannot tell the difference between

O≥06Ç÷ÖID and O≥06Ç÷öID

I've tried StrComp but it doesn't work on the non-standard characters. Is there any other way to work around this?


Thanks in advance.

Ken

 

[ByteMyzer]

You need to use the Binary Compare method, thus:

StrComp("O=06Ç÷ÖID", "O=06Ç÷öID", vbBinaryCompare)

 

[kherm]

Well on further reading, I'm finding that I am indeed using the binary compare. This is my field definition:

StrComp([field1],[field2],0)

According to Access help, the 0 is using the vbBinaryCompare. For some reason those two values are still equal in an Access join.

I really did not want to import this data into Oracle, but it looks like I'm going to have to.

I do appreciate your time and attention. Thank you!

Ken

 

[ByteMyzer]

Ahh, you did not speficy that you were attempting to enumerate fields from an Oracle data source. That makes a difference.

Retrieving direct values from data sources such as Oracle or Pervasive SQL, for example, cause case-sensitivity to go right out the window. Typically, in those cases, one has to read the data into variables and then enumerate the variables.

 

[kherm]

The target is an Oracle database. The source is a dbf database (foxpro) that loads easily into Access. But the problem is the source databases hex key field. If you're interested I'll let you know how Oracle handles the key.

Ken