Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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
Database name: test
Disk file: D:Projectsgreg1GITLagoMobileDBtest.udb
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

asked 15 Oct '13, 09:10

katalun4o's gravatar image

accept rate: 85%

edited 15 Oct '13, 13:25

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.

permanent link

answered 15 Oct '13, 09:54

Andy%20Quick's gravatar image

Andy Quick
accept rate: 45%

In short, please supply even brief information 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

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
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 15 Oct '13, 09:10

question was seen: 3,943 times

last updated: 16 Oct '13, 08:58