Thread

1. locale and german umlauts

   Wolfgang Winkler <wolfgang.winkler@digitali-concepts.com> — 2001-08-01T14:21:27Z

   Hi!
   
   I know that someone had problems before with the upper() and lower() 
   functions with german umlauts or polish signs. So could please anyone who 
   solved the problem tell me what to do to get the upper() and lower() 
   functions working properly?
   
   I compiled postgres 7.1.2 with 
   ./configure \
   --with-tcl \
   --with-java \
   --enable-locale
   make && make install
   initdb -D /usr/local/pgsql/data
   
   I set 
   
   export LC_CTYPE=de_DE.ISO8859-1
   export LC_COLLATE=de_DE.ISO8859-1
   
   and make a database with 
   
   createdb test.
   
   Is there something obvious I'm doing wrong?
   
   Thanks!
   
   
   
   

2. Re: locale and german umlauts

   Nishad Prakash <prakashn@uci.edu> — 2001-08-07T17:53:45Z

   On Wed, 1 Aug 2001, Wolfgang Winkler wrote:
   
   > export LC_CTYPE=de_DE.ISO8859-1
   > export LC_COLLATE=de_DE.ISO8859-1
   >
   > and make a database with
   >
   > createdb test.
   >
   > Is there something obvious I'm doing wrong?
   >
   
   Two things that could help:
   1) Make sure the locale has been set before starting the postmaster
   2) Try createdb -E <encoding> test
   
   Nishad
   -- 
   "Underneath the concrete, the dream is still alive" -- Talking Heads
   
   
   
   
   

3. Re: locale and german umlauts

   Nabil Sayegh <nsmail@sayegh.de> — 2001-08-07T18:37:26Z

   On 07 Aug 2001 10:53:45 -0700, Nishad Prakash wrote:
   > On Wed, 1 Aug 2001, Wolfgang Winkler wrote:
   > 
   > > export LC_CTYPE=de_DE.ISO8859-1
   > > export LC_COLLATE=de_DE.ISO8859-1
   
   If possible, you should use LC_COLLATE=POSIX
   everything else is AFAIR really slow.
   
   > 1) Make sure the locale has been set before starting the postmaster
   > 2) Try createdb -E <encoding> test
   
   1.1) set PGDATESTYLE=GERMAN before starting postmaster
   
   --
    Nabil Sayegh