Regarding double byte support

Tino,

Thanks for the information.
I already have a database with SQL_ASCII encoding.
Is there any way that I can change the encoding to UNICODE.

Regards,
Kallol.

-----Original Message-----
From: Tino Wildenhain [mailto:tino@wildenhain.de]
Sent: Friday, July 18, 2003 6:49 PM
To: Kallol Nandi
Subject: Re: [GENERAL] Regarding double byte support

Hi Kallol Nandi,

Kallol Nandi wrote:

Does Postgresql 7.2.1 support double byte characters?
If yes is then how to define fields that will contain double byte
characters?

Although you could define your own type, you can
use the database with UNICODE encoding (during
creation) then all text/char fields are utf8

This works pretty well for all languages.

Hoever there are also different encodings available,
I dont know how it is with chinese or such. But probably
its mapped internally to utf8 anyway.

Regards
Tino Wildenhain

Hi Kallol,

Kallol Nandi wrote:

Tino,

Thanks for the information.
I already have a database with SQL_ASCII encoding.
Is there any way that I can change the encoding to UNICODE.

The only way I know is pg_dump and dropdb, createdb and pg_restore.

HTH
Tino Wildenhain