Reading umlaut letters from sqlite database

[wysota]

Which version of SQLITE? How did you enter the data into the database? Don't use a separate text codec, the driver for sqlite should convert the data for you.

[Djony]

version is sqlite 3. I have already received database with names inside, and saw with different sqlite browsers that names are there and are entered correctly.

[wysota]

Does removing the extra codec help?

[Djony]

No. Actually, the first code I recieved didn't have that extra codec call. I added it, but it made no diference. Any more ideas?

[wysota]

Are you sure the data in the database is encoded in UTF-8?

[Djony]

As far as I know, Sqlite operate with UTF-8 encoding. Is there any way I can check that, and can you suggest me ony other encoding I could try? (I think that that could be checked with changing codec call in my codec, by trial and error repeating).

[wysota]

I had problems with SQLite and Qt myself and in the end it proved that the SQLite database was not UTF-8 encoded after all. So try fetching the data with some other mechanism (but not the sqlite3 console, it doesn't convert between local and utf - that was the base of my problems) and see if they are utf-8 encoded.

[Djony]

Thank you for your fast reply, but I didn't understand completely what you wrote. Can you go in more detail please? Which other mechanism to fetch data? I'm a bit confused, sorry.

[wysota]

Which other mechanism to fetch data?

SQLite C API.

[Djony]

You mean, to use sqlite c api (in some simple application) to read data from database and see are they in UTF-8 encoded?

[wysota]

Yes. That's exactly what I mean.