Hi Markus, thanks for this hint. Using an editor, I saw that the "Umlauts" are there. But is there a way to make the Umlauts visible also on the sqlite-commandline/sqlitebrowser (for select-statements necessary)?
Best regards, Wolfgang -------- Original-Nachricht -------- Datum: Wed, 20 Sep 2006 15:13:52 +0200 Von: Markus Hoenicka <[EMAIL PROTECTED]> An: Wolfgang Qual <[EMAIL PROTECTED]> Betreff: Re: [sqlite] German umlauts (äöüß) are not displayed in sqlite - solution > 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 -- NEU: GMX DSL Sofort-Start-Set - blitzschnell ins Internet! Echte DSL-Flatrate ab 0,- Euro* http://www.gmx.net/de/go/dsl ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
