Thread: Regarding double byte support
Does Postgresql 7.2.1 support double byte characters?
If yes is then how to define fields that will contain double byte characters?
Thanks and regards,
Kallol.
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 >