Re: unicode support vs native install

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