On 02/19/2014 11:42 AM, Dev Kumkar wrote:
On Wed, Feb 19, 2014 at 10:16 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> wrote: I found the below that might help. I do not use Windows much any more so I do not have a machine handy to confirm. http://www.g-loaded.eu/2011/02/27/locale-windows/ Thanks for the pointer. "*american_usa*" works however it sets the LC_COLLATE to 'English_United States.1252' which is basically "ANSI Latin 1" and is not utf8. The third parameter as the link says is codeset - "language_territory.codeset".
So what is the exact command you are using?
Here is the list of all codesets http://msdn.microsoft.com/en-us/library/dd317756%28VS.85%29.aspx but still no success. One of the link says codepage 65001 and utf-8 is same - http://stackoverflow.com/questions/1629437/is-codepage-65001-and-utf-8-the-same-thing. Am not able to find windows codeset equivalent of utf-8 and set it as LC_COLLATE while creating database. Has anyone set the LC_COLLATE as utf-8 on windows? Regards...
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
