Re: Unicode vs SQL_ASCII DBs - Mailing list pgsql-general

From Culley Harrelson
Subject Re: Unicode vs SQL_ASCII DBs
Date
Msg-id B62E7A65-5450-11D8-AA03-000A9591EB8C@fastmail.fm
Whole thread Raw
In response to Unicode vs SQL_ASCII DBs  ("John Sidney-Woollett" <johnsw@wardbrook.com>)
List pgsql-general
On Jan 31, 2004, at 7:32 AM, John Sidney-Woollett wrote:
>
> 4) I'm not initially expecting arabic, chinese, cyrillic or other
> language
> types to be stored in the database. But if they were, would UNICODE be
> the
> best encoding scheme to use for future proofing the data?
>

If there is a remote chance that you might ever need CJK support you
should start now with unicode encoding.  Switching the encoding of your
database is a major, major pain.  I have a SQL_ASCII database that I
wish were UNICODE but the conversion is such an ugly undertaking that I
haven't even tried.

culley


pgsql-general by date:

Previous
From: "Frank Millman"
Date:
Subject: Problem with function
Next
From: Tom Lane
Date:
Subject: Re: Problem with function