From: | Gerd Scheidhauer <gerd(at)gerdscheidhauer(dot)de> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | pgtcl and umlaut |
Date: | 2001-08-11 14:22:01 |
Message-ID: | 01081107220102.23258@quincy.outof.area |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Hello,
I'm using postgresql 7.0.2 on a PC running Linux (Mandrake 7.2). I'm
developing a application using the Tcl/Tk binding pgtcl (included in the
postgresql distribution).
I have problems with the german umlaut (ÄÖÜ): it is possible to insert and
read strings containing umlaut letters in a pgtcl application, but when the
database sorts the table, the sort order is wrong:
A Ä Ö Ü B C ...
instead of
A Ä B C ... O Ö P ... U Ü V ...
The database dump with otion -d (proper insert strings) prints
\303\204 for Ä
\303\226 for Ö
\303\234 for Ü
I tried differend encodings in the database (UNICODE, LATIN1, SQL_ASCII) as
well as in tcl (unicode, iso8859-1) but there was no impact on the sort
result.
You find a pgtcl script attached to this mail that demonstrates the problem.
Before starting the script you have to create a database:
createdb -E UNICODE sort_umlaut
then you have to run the script (pgtclsh must be installed in /usr/bin,
otherwise edit the first line of the script):
chmod u+x problem.tcl
./problem.tcl
The script prints the sorted table. Afterwards you can print the contents of
the database:
pg_dump -d sort_umlaut
Maybe somebody has a solution for the problem ;-)
Thanks in advance,
Gerd
--
Gerd Scheidhauer
http://www.gerdscheidhauer.de
phone:+49 721 722 34 16
Attachment | Content-Type | Size |
---|---|---|
problem.tcl | text/plain | 365 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-08-11 14:58:16 | Re: pgtcl and umlaut |
Previous Message | gerds | 2001-08-11 14:12:26 | pgtcl and umlaut |