pgman wrote:
> Eric J. Schwarzenbach wrote:
> > The Running & Installing PostgreSQL On Native Windows FAQ has an item on
> > not being able to use unicode
> >
> > http://pginstaller.projects.postgresql.org/FAQ_windows.html#2.6
> >
> > "/Because Postgres relies on the operating system for some string
> > related functions, the OS needs to support the same encoding as the one
> > that is used as the database encoding. Unfortunately, Windows does not
> > support some encodings that are available as server-side encodings for PG."
> >
> > /My understanding is the 8.0 windows installer prevents istalling utf-8
> > but you can get around it with initdb if you know what your doing.
> > Apparently only some things related to utf-8 data will be broken like
> > sort ordering.
> > /
> > /Does this apply to Cygwin installs of PostgreSQL as well?
>
> Yes, it does. The problem is that we only support UTF8 and Windows is
> UTF16. If you don't care about character ordering you can initdb with
> locale of C and use Unicode as your encoding.
>
Uh, this is assuming that Cygwin doesn't add UTF8 to Windows. I don't
think it does, but I am not sure.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073