Multiple languages in one database - Mailing list pgsql-admin

From Mont Rothstein
Subject Multiple languages in one database
Date
Msg-id 651dbef38351a356fc59cd02db5b38fd@yahoo.com
Whole thread Raw
Responses Re: Multiple languages in one database  (John DeSoi <desoi@pgedit.com>)
List pgsql-admin
I need to store multiple languages in one database (English, Spanish,
Chinese, Korean, ???).  At first I thought I would just us Unicode, but
then I realized that it is only UTF-8 and it is my understanding that
UTF-8 is insufficient for Chinese and Korean.  I state this because I
am starting to think that it is possible this assumption is incorrect.

My question is this, is anyone storing multiple languages (including
non-latin based languages such as Chinese and Korean) in one DB and if
so how?

My need is to store strings of text for each support language.  Ex: for
a given English string there would also be a Spanish, Chinese, and
Korean string.  This would then be used for language specific output in
web pages, print (PDF?), and in email.

I would really appreciate any help or pointers on this.

Thanks,
-Mont


pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Problem with backups and functions.
Next
From: "Joel Fradkin"
Date:
Subject: linux question might be bad forum for it.