Thread

1. UPPER and LOWER dosen't work correctly on special caracters (umlauts)

   PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2000-10-17T19:58:27Z

   Gert (Pache) reports a bug with a severity of 3
   The lower the number the more severe it is.
   
   Short Description
   UPPER and LOWER dosen't work correctly on special caracters (umlauts)
   
   Long Description
   The Upper- and the lower function don't convert the german umlauts (...) but leave them in their original condition
   
   Sample Code
   
   
   No file was uploaded with this report
   
   
   

2. Re: UPPER and LOWER dosen't work correctly on special caracters (umlauts)

   Nishad Prakash <prakashn@uci.edu> — 2000-10-17T20:51:09Z

   On Tue, 17 Oct 2000 pgsql-bugs@postgresql.org wrote:
   
   > Gert (Pache) reports a bug with a severity of 3
   > The lower the number the more severe it is.
   > 
   > Short Description
   > UPPER and LOWER dosen't work correctly on special caracters (umlauts)
   > 
   > Long Description
   > The Upper- and the lower function don't convert the german umlauts (...) 
   > but leave them in their original condition
   > 
   > Sample Code
   > 
   > 
   > No file was uploaded with this report
   > 
   
   You can make this work with some help from your OS.  Have your locale set
   correctly to recognize non-ascii characters when postmaster starts.  I did
   it by setting LC_CTYPE to iso_8859_1 in the postgres superuser's shell
   initialization file.  Note that this won't work unless the locale is
   actually available on your machine; you can't just type the same thing I
   did and hope for the best.
   
   
   If it helps, this is from the postgres superuser's shell at our site:
   [1:42pm] /data/postgres> uname -a
   SunOS ptolemy.tlg.uci.edu 5.6 Generic_105181-08 sun4u sparc SUNW,Ultra-5_10
   
   [1:43pm] /data/postgres> locale
   LANG=
   LC_CTYPE=iso_8859_1
   LC_NUMERIC="C"
   LC_TIME="C"
   LC_COLLATE="C"
   LC_MONETARY="C"
   LC_MESSAGES="C"
   LC_ALL=
   
   This is not a complete solution (collation is still incorrect) but it
   should get you started.  Hope it helps.
   
   Nishad
   -- 
   "Underneath the concrete, the dream is still alive" -- Talking Heads
   
   
   
   

3. Re: UPPER and LOWER dosen't work correctly on special caracters (umlauts)

   Thomas Lockhart <lockhart@alumni.caltech.edu> — 2000-10-18T05:18:08Z

   > The Upper- and the lower function don't convert the german umlauts (ü.ä.ö.) but leave them in their original condition
   
   Gert (or anyone): what should the result be? I'm German-impaired, so
   you'll need to be more specific. Did you compile with locale turned on?
   Multi-byte character sets?? Which byte codes correspond to the lower-
   and upper-case umlaut characters???
   
                          - Thomas
   
   

4. AW: UPPER and LOWER dosen't work correctly on special caracters (umlauts)

   Ronald Kuczek <ronald@unix.breitenbach-it.de> — 2000-10-18T06:34:25Z

   You need to enable locale support (see documentation).
   Best regards
   Rony
   
   > -----Ursprüngliche Nachricht-----
   > Von: pgsql-bugs-owner@hub.org [mailto:pgsql-bugs-owner@hub.org]Im
   > Auftrag von pgsql-bugs@postgresql.org
   > Gesendet: 17 paŸdziernika 2000 21:58
   > An: pgsql-bugs@postgresql.org
   > Betreff: [BUGS] UPPER and LOWER dosen't work correctly on special
   > caracters (umlauts)
   >
   >
   > Gert (Pache) reports a bug with a severity of 3
   > The lower the number the more severe it is.
   >
   > Short Description
   > UPPER and LOWER dosen't work correctly on special caracters (umlauts)
   >
   > Long Description
   > The Upper- and the lower function don't convert the german
   > umlauts (ü.ä.ö.) but leave them in their original condition
   >
   > Sample Code
   >
   >
   > No file was uploaded with this report
   >