Re: Japanese Character Support - Mailing list pgsql-admin

From Björn Metzdorf
Subject Re: Japanese Character Support
Date
Msg-id 001e01c33cdf$c665a6b0$0564a8c0@shock
Whole thread Raw
In response to Japanese Character Support  (Tom Haddon <tom@betterhealthfoundation.org>)
List pgsql-admin
> I'd like to be able to support both Japanese and English character
> sets in the same database if possible. First off, is this possible,
> or are there some restrictions (such as specific tables need to have
> specific character sets only).
>
> I think this is a case of Multi-Byte Support. If this is the case, how
> do I determine if my web-host's database was compiled with support for
> that, and if it wasn't is there any way around it, besides
> reinstalling the database?

what you need is Unicode-support in your database and application (often
referred to as UTF-8).

Have a look at

http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=multibyte.ht
ml

Postgresql can automagically convert between different encodings, this way
your application does not have to be modified too heavily.

Regards,
Bjoern


pgsql-admin by date:

Previous
From: Tom Haddon
Date:
Subject: Japanese Character Support
Next
From: weigelt@metux.de
Date:
Subject: Re: Postgres RoadMap