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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
