Improper retrieval of Spanish text from SQlite in Blackberry

Question

Hi Folks,

I have stored Spanish text into the SQlite database and I am retrieving the same through the java code using row.getString() method of BlackBerry API, But I am unable to fetch the exact text from the database, only the accent characters are displaying differently in to the device(BlackBerry bold 9700). Where I am doing wrong please point me to the right direction.

Best Regards,

Vinayak

Answer 1

This looks like a problem with the encoding. You have to use the same encoding when loading the text as you used when storing it. This blog is a good reference for unicode problems.

Answer 2

It is surely a problem with the Charset encoding. It's a common problem using spanish accents and tildes. The SQLite uses UTF-8, so you have to check if your application uses UTF-8 or else.

EDIT: set the default encoding at BlackBerry API You have to set the system property microedition.encoding. Reference: http://www.blackberry.com/developers/docs/4.5.0api/java/lang/System.html

You can set this property at the command line: java -Dmicroedition.encoding="UTF-8" MyApp

Answer 3

row.getString() does not allow any specification of the encoding - so the OS code should be doing the right thing when retrieving a string from the database. My experience with SQLite on BlackBerry is that OS builds around 5.0.0.4xx have a bug where the database encoding is not respected on retrieval. I've had to work around this by doing

new String(row.getString().getBytes(), "UTF-8")

But of course, only on the problematic OS versions, as this would break any correct implementation of row.getString().

The versions with this issue that I've encountered so far are: 5.0.0.442 and 5.0.0.423