Multiple languages in one database

From: Mont Rothstein <mont_rothstein(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Multiple languages in one database
Date: 2005-03-18 22:54:14
Message-ID: 651dbef38351a356fc59cd02db5b38fd@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joel Fradkin 2005-03-18 23:59:48 linux question might be bad forum for it.
Previous Message Joshua D. Drake 2005-03-18 20:54:27 Re: Problem with backups and functions.