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, 200718 yr by Guest

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.

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.

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.