Обсуждение: 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

> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>