Hello, I have a problem with a Like statement in UltraliteJ. I need to be able to search case insensitive a column with Greek text in my database but it is not working. Works only for ASCII characters. I saw that problem for SQLite and I wonder if there is a workaround in Ultralitej ? The version of SQLAnywhere is 12 and I am using it in Xamarin Monodroid - UltraliteMono.dll
And this is the ulinfo:
D:Program FilesSQL Anywhere 12Bin32>ulinfo -c dbf=D:Projectsgreg1GITLagoM
There could be a workaround. Please give more details, ie. What is the exact version of SQL Anywhere that you are using? What is the character set of the UltraLite database file? (eg. ulinfo output) What is the schema and contents of the table on which you are searching. What is the query you are using? In short, please supply even brief information that we could use to reproduce the problem. Thanks.
answered 15 Oct '13, 09:54