Roger, Am 24.04.2012 um 06:41 schrieb Roger Gilliar:
See UTF8TextConverter --------------------------------- Thanks for the tip. But shouldn't that be done by the system. The database uses UTF-8. Pharo uses UTF-8 so an à in the database should give me an à in the transcript window.
BTW: I tried the UTF8TextConverter and it just produces more garbage.
pharo does not use UTF-8. It uses multibyte Characters. UTF-8 is a storage format. If you really get UTF-8 from sqlite than the TextConverter is the right thing to do. So let's take a lowercase ö. If you see something like ö where the ö should be than you can be sure it is utf-8 encoded. Then you can do UTF8TextConverter new nextFromStream: 'ö' asString readStream to test it and get $ö. If you get something different then the encoding you get from sqlite is not UTF-8. You should ask yourself who put that string into sqlite. It might be a storage failure as well. Sqlite would probably just convert everything into UTF-8 regardless what you give to it. Norbert