Skip site navigation (1) Skip section navigation (2)

pgtcl and umlaut

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 (view raw or flat)
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: problem.tcl
Description: text/plain (365 bytes)

Responses

pgsql-interfaces by date

Next:From: Tom LaneDate: 2001-08-11 14:58:16
Subject: Re: pgtcl and umlaut
Previous:From: gerdsDate: 2001-08-11 14:12:26
Subject: pgtcl and umlaut

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group