case insensitive keys

[Andreas Nef]

I'm using Access 97. I have created a unique key including one text field.
When I add a record with 'a' as this field's value I get an error message
because of a duplicate value in the index. I already have a record with a
capital 'A' which I have figured out to be the reason for the error.
Is it true, then, that the indices of MS Access (97?) are case insensitive?

Andreas

 

[Rick Brandt]

I'm using Access 97. I have created a unique key including one text
field. When I add a record with 'a' as this field's value I get an
error message because of a duplicate value in the index. I already
have a record with a capital 'A' which I have figured out to be the
reason for the error.
Is it true, then, that the indices of MS Access (97?) are case
insensitive?

Andreas

Yep, and there is no way to make them case sensitive. You can simulate case
sensitivity in searchs and filters with some of the VBA functions, but there
is no way to make indexes and keys case sensitive at the engine level.

 

[peregenem]

I'm using Access 97. I have created a unique key including one text field.
When I add a record with 'a' as this field's value I get an error message
because of a duplicate value in the index. I already have a record with a
capital 'A' which I have figured out to be the reason for the error.
Is it true, then, that the indices of MS Access (97?) are case insensitive?

Jet data type is case insensitive

CREATE TABLE Test (key_col INTEGER, data_col TEXT(50))
INSERT INTO Test VALUES (1, 'HELLO')
INSERT INTO Test VALUES (2, 'hello')
SELECT * FROM Test WHERE data_col = 'HELLO'
SELECT data_col, COUNT(*) FROM Test GROUP BY data_col
SELECT * FROM Test AS T1 INNER JOIN Test AS T2 ON T1.data_col =
T2.data_col