From: | Jasen Betts <jasen(at)xnet(dot)co(dot)nz> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | win Locales - "Arabic, Gum" |
Date: | 2011-02-03 12:46:09 |
Message-ID: | iie82h$bs1$1@reversiblemaps.ath.cx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
What's the deal with locale codes on windows.
especially the settings like LC_NUMERIC ansd LC_MONETARY
on windows XP in 9.0 "show LC_MONETARY" displays them as "Arabic, Bharain"
or "English, UK", "French, Canada" but everything right of the comma
seems to be ignored. (resulting in incorrect currency display for the
money type in all the above). This is further evidenced by nonsense
locales like "Arabic, Gum" and "English, Spin" and "Frech, Toast" being
accepted by postgres.
fortunately you can get the correct behaviour by using an '_' in
plase of ', ' (I note that the documentations says to use underscore)
"Arabic_Bharain", "English_UK", "French_Canada"
The windows installer (initdb?) isn't smart enough to do this when
creating template1, it uses ', ' which fails to select the correct locale
silently whilst appearing to the untrained eye to have worked :(
--
⚂⚃ 100% natural
From | Date | Subject | |
---|---|---|---|
Next Message | Sim Zacks | 2011-02-03 12:51:41 | Re: Database Design Question |
Previous Message | hlcborg | 2011-02-03 12:38:23 | Re: Problem with encode () and hmac() in pgcrypto |