Thread: Japanese Character Support

Hi Folks,

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?

Thanks, Tom
--
________________________________
Tom Haddon
IT Director
The Better Health Foundation
414 Thirteenth Street, Suite 450
Oakland, CA   94612
(510) 444-5096
(510) 444-5085 FAX
www.betterhealthfoundation.org
________________________________

> 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