pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mont Rothstein <mont_rothstein@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Multiple languages in one database
Date: Fri, 18 Mar 2005 14:54:14 -0800
Message-ID: <651dbef38351a356fc59cd02db5b38fd@yahoo.com> (raw)

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




view thread (3+ messages)  latest in thread

Message-ID: <651dbef38351a356fc59cd02db5b38fd@yahoo.com>
Permalink:  ../651dbef38351a356fc59cd02db5b38fd@yahoo.com/
Also on:    postgresql.org/message-id/651dbef38351a356fc59cd02db5b38fd@yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: mont_rothstein@yahoo.com
  Subject: Re: Multiple languages in one database
  In-Reply-To: <651dbef38351a356fc59cd02db5b38fd@yahoo.com>
  References: <651dbef38351a356fc59cd02db5b38fd@yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox