SQLite Case Insensitive LIKE for Unicode characters

[Diamond]

Please explain how to achieve case insensitive LIKE for non-ASCII characters with SQLiteUniProvider.

I've tried to add "COLLATE UniNoCase" after LIKE statement, but it didn't help. (DefaultCollations=True)

UniDAC version: 4.1.4
Delphi 2007 & Delphi XE

[AlexP]

Hello,

The Like method doesn't support Collation (more details on using the Collate are available at http://www.sqlite.org/datatype3.html in the Assigning Collating Sequences from SQL section). Therefore you should specify UTF symbols in both cases when using the Like method:

Code: Select all

WHERE (column like '%UTF_SYMBOL%' or column like '%utf_symbol%' )

or create and register your own user function for setting UTF-strings to upper/lower case and use it as

Code: Select all

WHERE MY_UPPER(column) like '%UTF_SYMBOL%'

You can find the information about creation of user functions in the TLiteUtils.RegisterFunction Method section of the help.