What you see is not necessarily what sqlite returns. It depends on your shell whether the UTF-8 output of sqlite (or of any other app) is displayed correctly or displayed at all. To check whether the output (as opposed to the screen display) is correct, you can either pass the output to less (it will display Umlauts as something like "<C3><B6>") or redirect it into a file which you can inspect with an UTF-8 capable editor like Emacs.
regards, Markus Wolfgang Qual <[EMAIL PROTECTED]> was heard to say: > Hi list, > I have a problem with german umlaut-characters (ä,ö,ü,ß) in sqlite - they are > not displayed both in sqlite-command line and in sqlitebrowser. Background: I > use sqlite3 as a database for the open source GIS GRASS: inside GRASS, I > imported a dbf-table into the sqlite-database. > Is there a way to tell sqlite/sqlitebrowser that I have data containing > german umlaut characters? > -- Markus Hoenicka [EMAIL PROTECTED] (Spam-protected email: replace the quadrupeds with "mhoenicka") http://www.mhoenicka.de ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
