case insensitive keys

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andreas Nef - 19 Jul 2005 14:33 GMT

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

Reply to this Message

Rick Brandt - 19 Jul 2005 15:04 GMT

> 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
[quoted text clipped - 5 lines]
>
> 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.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

peregenem@jetemail.net - 19 Jul 2005 15:12 GMT

> 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

Reply to this Message