[Pharo-users] Bad UT8 encoding got with a SQLite3 query

[Michel]

Hi everyone,

I have a sqlite3 data base which is UTF8 encoded. Accessing to it with a 
ruby script gives me the right encoding for accented vowel, and doing an 
hexdump of the file too, but I get a strange one with the sqlite3 
package in pharo 2.0.

For example, for 'é' (UTF8 0xC3A9) I get 0xA6A9, for 'è' (UTF8 0xC3A8) I 
get 0xA6AE, for 'à' (UTF8 0xC3A0) I get 0xA686, for 'ù' (UTF8 0xC3B9) I 
get 0xA69A, ...

Looking at the smalltalk code I didn't see any translation and of course 
if I attempt to use the UTF8TextConverter I get an error.

Any idea ?

Thanks in advance.
Michel.