Case insensitive search for unicode text

[Former Member]

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
SQL Anywhere UltraLite Information Utility Version 12.0.1.3457
Database name: test
Disk file: D:Projectsgreg1GITLagoMobileDBtest.udb
Users:
1. User: 'DBA'
Collation sequence: 1252LATIN1
Character set encoding: UTF8
Page size: 4096
Default index maximum hash size: 4
Checksum level: 0
Global database ID: 2147483647
Global autoincrement usage: 0%
MobiLink Remote ID: a2e00c00-35e2-11e3-8000-b837c3af39c7
Encryption: None
Respect letter-case when comparing: No ('A' equal to 'a')
Date format: YYYY-MM-DD
Date order: YMD
Nearest century: 50
Numeric precision: 30
Numeric scale: 6
Time format: HH:NN:SS.SSS
Timestamp format: YYYY-MM-DD HH:NN:SS.SSS
Timestamp with time zone format: YYYY-MM-DD HH:NN:SS.SSS+HH:NN
Timestamp increment: 1
Last synchronization completed successfully
Download timestamp: 2013-10-15 18:49:04.000
Upload OK
No ignored rows
No part download remaining
Authentication value: 1000 (0x03e8)
Synchronization by publication number:
1. Publication pblErrors
Number of rows in next upload: 0
Last download: 1900-01-01 00:00:00.000
2. Publication pblUploadTrans
Number of rows in next upload: 0
Last download: 1900-01-01 00:00:00.000
3. Publication pblUsers
Number of rows in next upload: 0
Last download: 2013-10-15 18:43:37.327000
4. Publication pblMain1
Number of rows in next upload: 0
Last download: 2013-10-15 18:43:48.470000

[Former Member · Accepted solution]

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.

[VolkerBarth · Accepted solution]

In short, please supply even brief information

...to prevent that from becoming an "expensive case" search, I'd say:)

[philippefbertrand · Accepted solution]

Please confirm the target platform is Android (versus BlackBerry).

[Former Member · Accepted solution]

I edited my question with more info, yes the target is Android

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

Setting the collation of the database to "1253ELL" fixed the problem, thank you.