Skip site navigation (1) Skip section navigation (2)

Re: trouble with to_char('L')

From: Mikko <mhannesy(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: trouble with to_char('L')
Date: 2009-04-22 17:06:24
Message-ID: 40c6d9160904221006k202284c8y305123f66beeaacb@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
On Wed, Apr 22, 2009 at 2:13 AM, Alvaro Herrera
<alvherre(at)commandprompt(dot)com> wrote:
> Ouch ... I thought that was the way that Windows designated UTF8
> locales, but maybe I am wrong.

Ok, now I found out that Windows doesn't support locales with encoding
using more than two bytes per character and initdb falls back to 1252.

http://msdn.microsoft.com/en-us/library/x99tb11d.aspx

I guess I'll have to manage with win1252 encoded dbs for the moment.
Thanks for the answers!

Mikko

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-04-22 17:48:31
Subject: Prepared transactions vs novice DBAs, again
Previous:From: Robert CampbellDate: 2009-04-22 16:50:38
Subject: Re: Workaround for bug #4608?

pgsql-general by date

Next:From: Raymond O'DonnellDate: 2009-04-22 17:09:15
Subject: Re: Error installing Postgres
Previous:From: Joshua D. DrakeDate: 2009-04-22 16:56:23
Subject: Re: From 8.1 to 8.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group