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
  [email protected]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [email protected]