UTF8 server-side on Win32?

Alvaro Herrera <alvherre@commandprompt.com> writes:

Is there any way to select the UTF-8 as server-side encoding at initdb
time?

This guy reported he wasn't able to do it:
http://archives.postgresql.org/pgsql-hackers-win32/2004-11/msg00062.php

That was 8.0. My recollection is we fixed it for 8.1. You might have
to use an explicit --encoding switch, because I don't think Windows has
any locale settings that map to utf8, but I might be wrong ...

regards, tom lane

Is there any way to select the UTF-8 as server-side

encoding at initdb

time?

This guy reported he wasn't able to do it:

http://archives.postgresql.org/pgsql-hackers-win32/2004-11/msg00062.ph

p

That was 8.0. My recollection is we fixed it for 8.1. You
might have to use an explicit --encoding switch, because I
don't think Windows has any locale settings that map to utf8,
but I might be wrong ...

Yup, it was fixed in 8.1.
The installer for 8.1 will let you pick UNICODE encoding during setup.

//Magnus

Magnus Hagander wrote:

Is there any way to select the UTF-8 as server-side

encoding at initdb

time?

This guy reported he wasn't able to do it:

http://archives.postgresql.org/pgsql-hackers-win32/2004-11/msg00062.ph

p

That was 8.0. My recollection is we fixed it for 8.1. You
might have to use an explicit --encoding switch, because I
don't think Windows has any locale settings that map to utf8,
but I might be wrong ...

Yup, it was fixed in 8.1.

Ok, thanks.

The installer for 8.1 will let you pick UNICODE encoding during setup.

What if he uses initdb directly?

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

The installer for 8.1 will let you pick UNICODE encoding

during setup.

What if he uses initdb directly?

Then it should be a simple "-E UNICODE", just as on unix.

//Magnus