win Locales - "Arabic, Gum"

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

Browse pgsql-general by date

  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