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
