Re: [HACKERS] UTF8 server-side on Win32?
>> > 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 Hello, I'm the guy that post this question on psql-es-ayuda. Thanks to Alvaro for forward here. I would like explain the question: I can do initdb with '-E UTF8' or '-E UNICODE' on windows without problem. But the --locale switch do not permit set to 'Spanish_Spain.UNICODE', 'Spanish_Spain.UTF8' or 'Spanish_Spain.65001'. I put the locale to Spanish_Spain.1252 (Ansi encoding) and seem to work well with database encoding UTF8. I'm not an encoding expert but i think that the database encoding and the right side of locale specification may be the same for a correct work. Am i wrong, and -E UTF8 may cohabitate with locale windows ansi 1252 without problems? Thanks -- * Oswaldo Hernández [EMAIL PROTECTED] * ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] UTF8 server-side on Win32?
> > 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 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [HACKERS] UTF8 server-side on Win32?
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 Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] UTF8 server-side on Win32?
> > 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 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] UTF8 server-side on Win32?
Alvaro Herrera <[EMAIL PROTECTED]> 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 ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
