Search not case sensitive...

how can I set "data assist search" to ignore caps?

If you are using PHP / MySQL, Case sensitivity is set on the database end by the collation and character set that are selected when the table is created. The default character set and collation are latin1 and latin1_swedish_ci which are not case sensitive in string comparisons.

If you are using The MySQL GUI Tools for creating your table, go to the MySQL Administrator. In the Catalog section select you schema then double click the table that is being used by DataAssist to open the table editor. On the Table Options tab you can change the Character set and Collation.

More on case sensitivity in MySQL can be found here:
case-sensitivity.html

I am struggling with this.
In very simple terms, I think that if my db and table are set to latin1_swedish_ci then my search should be Case Insensitive, however, that is not the case.
What am I missing?

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.