| From: | service prodat <service(at)prodat-sql(dot)de> | 
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org | 
| Subject: | UNIX vs Windows LC CTYPE and UPPER mu | 
| Date: | 2012-04-18 12:03:15 | 
| Message-ID: | jmmai3$15o3$1@news.hub.org | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-admin | 
Hello,
first: i hope im right here in this mailing list.
My problem:
We have several Postgre servers 9.0.4, one on Windows Server 2008 R2 and 
others on different UNIX/Linux systems.
Windows: LC_CTYPE = 'German, Germany'
UNIX: LC_CTYPE='de_DE.UTF-8'
(so LC_COLLATE is too)
on both systems
ENCODING = 'UTF8'
Now the function UPPER('µ') works right on Windows, giving me 'µ' 
(unicode = 181 respectivly U+00B5).
On Unix I get a char like M (unicode = 924 respectivlyU+039C), the GREEK 
CAPITAL LETTER MU
But we are not in Greek.
Is this a Unix based problem with a wrong local setup (we dont think so, 
servers local working on other german letters like ä, ö, ü and UPPER too),
or a Unix local problem in principle,
or a wrong postgre server setup,
or a postgre bug?
Or is this a feature, not a bug.
We dont know where to search or where to fix something.
Thank you for concerning,
Dominik
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rural Hunter | 2012-04-18 13:21:15 | Re: invalid byte sequence for encoding "UTF8": 0xf481 - how could this happen? | 
| Previous Message | Chris Ernst | 2012-04-18 00:03:37 | Re: Recreate primary key without dropping foreign keys? |