[GRASS-user] GRASS, sqlite-driver an (german) umlaut - visible in GRASS, but not in sqlite!

GRASS GRASS user
,
1

Dear list,
I successfully imported a dbf-table into my grass-project. Attributes are stored in sqlite.
When I use the identify-tool of gis.m, german umlaut characters (üßöä)are displayed. However, using sqlite3-console or sqlitebrowser does not work. The same thing happens with QGIS (not displayed). Therefore, I cannot perform a query like "select * from layer where Ort like 'Münch%';" (only Mnchen available).
Is there a way to tell sqlite that I have this kind of characters?
I just tested v.out.ogr - fortunately, all ü,ö,ä,ß were visible in the attribute table of the exported (shape-)file.

Any ideas are appreciated!

With best regards,
Wolfgang

--
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer

2

Hello Wolfgang,

On Wed, 20 Sep 2006 10:27:40 +0200 "Wolfgang Qual"
<Wolfgang.Qual@gmx.net> wrote:

Dear list,
I successfully imported a dbf-table into my grass-project. Attributes
are stored in sqlite. When I use the identify-tool of gis.m, german
umlaut characters (üßöä)are displayed. However, using sqlite3-console
or sqlitebrowser does not work. The same thing happens with QGIS (not
displayed). Therefore, I cannot perform a query like "select * from
layer where Ort like 'Münch%';" (only Mnchen available). Is there a
way to tell sqlite that I have this kind of characters? I just tested
v.out.ogr - fortunately, all ü,ö,ä,ß were visible in the attribute
table of the exported (shape-)file.

Any ideas are appreciated!

Did you check our locale-settings? Are they set correct for your
environment and for the sqlite-db as well?

Best regards
  
  Stephan

--
GDF Hannover - Solutions for spatial data analysis and remote sensing
Hannover Office - Mengendamm 16d - D-30177 Hannover
Internet: www.gdf-hannover.de - Email: holl@gdf-hannover.de
Phone : ++49-(0)511.39088507 - Fax: ++49-(0)511.39088508

3

Hi Stephan,

Did you check our locale-settings? Are they set correct for your
environment and for the sqlite-db as well?

I fear that I do not really understand, what you mean. Could you give me some additional info, where to look? printenv? When I type in "printenv" I get these information reg. language:

LANG=de_DE.UTF-8
LANGUAGE=\\\"de_DE:de:en_GB:en\\\"

As mentioned before, the umlaut(s) are displayed correctly in gis.m

Best regards,
Wolfgang

Best regards
  
  Stephan

--
GDF Hannover - Solutions for spatial data analysis and remote sensing
Hannover Office - Mengendamm 16d - D-30177 Hannover
Internet: www.gdf-hannover.de - Email: holl@gdf-hannover.de
Phone : ++49-(0)511.39088507 - Fax: ++49-(0)511.39088508

_______________________________________________
grassuser mailing list
grassuser@grass.itc.it
http://grass.itc.it/mailman/listinfo/grassuser

--
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer

4

Hello list, Stephan,
just a short remark to the above desribed problem.
When using xterm as the terminal programme, umlauts are correctly displayed in the command-line of sqlite (before, I used "konsole", a kde-application).
This gives me the possibility to perform sql-statements, which contain umlauts. However, this does not solve the sqlitebrowser-problem - could it be a qt3-issue? Anyway, I asked this question on the sqlite-user-list [1].

Best regards,
Wolfgang

[1] http://www.mail-archive.com/sqlite-users%40sqlite.org/msg18389.html

-------- Original-Nachricht --------
Datum: Wed, 20 Sep 2006 12:36:35 +0200
Von: "Wolfgang Qual" <Wolfgang.Qual@gmx.net>
An: Stephan Holl <holl@gdf-hannover.de>, grassuser@grass.itc.it
Betreff: Re: [GRASS-user] GRASS, sqlite-driver an (german) umlaut - visible in GRASS, but not in sqlite!

Hi Stephan,
> Did you check our locale-settings? Are they set correct for your
> environment and for the sqlite-db as well?
I fear that I do not really understand, what you mean. Could you give me
some additional info, where to look? printenv? When I type in "printenv" I
get these information reg. language:

LANG=de_DE.UTF-8
LANGUAGE=\\\"de_DE:de:en_GB:en\\\"

As mentioned before, the umlaut(s) are displayed correctly in gis.m

Best regards,
Wolfgang

>
> Best regards
>
> Stephan
>
> --
> GDF Hannover - Solutions for spatial data analysis and remote sensing
> Hannover Office - Mengendamm 16d - D-30177 Hannover
> Internet: www.gdf-hannover.de - Email: holl@gdf-hannover.de
> Phone : ++49-(0)511.39088507 - Fax: ++49-(0)511.39088508
>
> _______________________________________________
> grassuser mailing list
> grassuser@grass.itc.it
> http://grass.itc.it/mailman/listinfo/grassuser

--
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer

_______________________________________________
grassuser mailing list
grassuser@grass.itc.it
http://grass.itc.it/mailman/listinfo/grassuser

--
NEU: GMX DSL Sofort-Start-Set - blitzschnell ins Internet!
Echte DSL-Flatrate ab 0,- Euro* http://www.gmx.net/de/go/dsl

5

Hello Wolfgang,

On Thu, 21 Sep 2006 10:25:34 +0200 "Wolfgang Qual"
<Wolfgang.Qual@gmx.net> wrote:

Hello list, Stephan,
just a short remark to the above desribed problem.
When using xterm as the terminal programme, umlauts are correctly
displayed in the command-line of sqlite (before, I used "konsole", a
kde-application).

Strange, I use the KDE- konsole and the umlauts are printed fine.
Perhaps an KDE-UTF8-issue?!

This gives me the possibility to perform
sql-statements, which contain umlauts. However, this does not solve
the sqlitebrowser-problem - could it be a qt3-issue? Anyway, I asked
this question on the sqlite-user-list [1].

AFAIK sqlitebrowser should grab the locale-setting from KDE
environment, but I am not quite sure.

Cheers
  Stephan
--
GDF Hannover - Solutions for spatial data analysis and remote sensing
Hannover Office - Mengendamm 16d - D-30177 Hannover
Internet: www.gdf-hannover.de - Email: holl@gdf-hannover.de
Phone : ++49-(0)511.39088507 - Fax: ++49-(0)511.39088508