Re: Unicode support on Win32 - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Unicode support on Win32
Date
Msg-id 200502281857.j1SIvNZ26347@candle.pha.pa.us
Whole thread Raw
In response to Unicode support on Win32  (Caleb <caleb_ownz@yahoo.com>)
Responses Re: Unicode support on Win32
List pgsql-general
Caleb wrote:
> Hi,
>
> I am using Windows as a development environment (and database design),
> and  it seems that Unicode is not supported on Win32.

Yes, the problem is that we only support UTF-8 and the Win32 collation
routines only support UTF-16.  You can actually use UTF-8 if you don't
care about ordering of the character set, but pginstaller doesn't
support those options --- you have to run initdb manually.

> Is there word on when Unicode support will be implemented on the
> Windows port of PostgreSQL?
>
> I was used to using mySQL and it supported Unicode on Windows
> properly.. But I suppose that the Windows port of PostgreSQL is still
> working in progress.

It is not a "work in progress" as far as we are concerned.  You have hit
a limitation, but it is ready for serious use.

> On the other hand, could I pick a different charset for now, and when I
> need to copy this whole database to a production machine (that will use
> linux) choose the UTF-8 charset ?

Yes.

> I also don't seem to understand why you need to define the whole
> database as unicode ? Don't you only need unicode for certain fields,
> and the rest can be Latin1?

No, we don't support per-table or per-column encodings yet either.

--
  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

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: Reading from Mysql & writting in PGsql
Next
From: Ragnar Hafstað
Date:
Subject: Re: Problems with pgcrypto and special characters