How do I set up Access (2K) for Option Compare Binary?

[Rover]

I need for all compares in queries, keys etc. to differentiate between
upper and lower case. How can I do that?

I have imported data that uses as the key a field that uses a different
meaning for an uppercase letter and the same letter lower case. I tried
to set that field as the key and it thinks there are duplicates. I can
NOT use a autonumber or similar mechanism as this problem will exist
when I try to link to that field from other tables. An "a" is not equal
to an "A".

Suggestions?

TIA
Jim

 

[david epsom dot com dot au]

Create a binary field instead of text field. The access
interface does not allow you create fields of type binary,
so you will have to use DDL or DAO to create the field.

(The Access interface supports BLOB fields, and Memo
fields: that is not what I am talking about: I am talking
about the 255 character binary field, which is NOT
supported by the Access interface.)


Text fields are by definition not case sensitive. You
can do case sensitive comparisons on the data in a
text field, but any index will always use the national
language definition of upper case / lower case.
Unfortunately, there is no language you can select
which does not have upper case/ lower case (I think
that would be an interesting solution, although
probably not very useful, since it is a database
setting, not a column setting.)

Binary fields are by definition not text. They do not
sort as text, they do not compare as text, and they
are not indexed as text.

(david)