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
obileDBtest.udb |
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.
...to prevent that from becoming an "expensive case" search, I'd say:)
(15 Oct '13, 10:02)
Volker Barth
Please confirm the target platform is Android (versus BlackBerry).
(15 Oct '13, 10:41)
PhilippeBert...
I edited my question with more info, yes the target is Android
(15 Oct '13, 13:17)
katalun4o
3
Could it be that you should be using collation sequence "1253ELL"? (see ulinit -Z for a list of supported collations). If that does not work, I am going to need some sample data (say UTF8 characters) and a query that gives incorrect results.
(15 Oct '13, 16:24)
Andy Quick
Setting the collation of the database to "1253ELL" fixed the problem, thank you.
(16 Oct '13, 08:58)
katalun4o
|