nathanvi wrote:
Strings are in utf8 encoding. My system has utf8 locales too.
I've a lot of problem with accents as èéàòù.
I inserted them in a field. When i make a select of that field, i obtain right accents via shell: sqlite db.sqlite 'select frase from logchan limit 16660' => èéàòù
On the contrary, if i look for that field via sqlitebrowser or
phpsqliteadmin it result bad: ©Ã¹ÃÂ
Looks like that's sqlitebrowser and phpsqliteadmin fault.
Sqlite itself and the console tool 'sqlite' doesn't know anything about utf-8 or encodings, because it doesn't matters to sqlite.
Maybee your tools are interpreting the bytes stored in the database as iso8859-xx encodings. IIRC your results show that the two tools you use are asuming iso8859-1 in the database, which if of course wrong.
cu
Michael
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
