ODBC Case sensitive?

[Jim1]

Hi, I currently use ODBC for communicating with FileMaker. I was wondering if FileMaker is case-sensitive as it appears to be with my queries. Can I change the field type to another storage type which is not case-sensitive(unicode) and does anyone know what this is?

For example with MySQL you can set a field to unicode to be case-sensitive, but FileMaker appears to be case-sensitive what ever field storage type I select. Anyone with any experience on this topic?

Thanks,

Jim.

Edited February 5, 2007 by Guest

[ave!]

You can execute case-insensitive search like below.

SELECT * FROM "database_name" WHERE LOWER(field_name) = LOWER(condition)

Though I'm not sure if this is what you want, hope this helps.

[Jim1]

Thank you for your reply. My concern is the overhead (time) that the SQL takes to convert the column data into lowercase.

I think that case sensitivity is a poor oversight on the behalf of FileMaker/Datadirect as you do not have this issue with MySQL. Just an observation.

I hope this case sensitivity post is useful to people. Thanks,

Jim.

[Jim1]

Back to this old topic. Still case-sensitive.

The quickest way are this I have found is to have a field called "my_search_field_lower", which is an auto-enter field "lower(my_search_field)".

Then the value is am searching for is also converted to lower case:

SELECT * FROM TABLE WHERE my_search_field_lower = 'converted_to_lower_string'.

HTH others.