Обсуждение: Multilingual database

Hi!

I would like to store the title and description of a
product in different languages.  Should I use unicode
(UTF-8) to store the different languages in one
database, or I should initialize different databases
for the different languages?  I appreciate if someone
can give me some suggestions and what I should aware
of.  I have use the keyword "multilingual" to search
the achrieves but cannot find an answer.

Terence


_________________________________________________________
第二世(謝霆鋒)，習慣失戀(容祖兒)，兄妹(陳奕迅)...
Yahoo! 鈴聲下載
http://ringtone.yahoo.com.hk

On Friday 09 May 2003 03:32, Terence Ng wrote:
> Hi!
>
> I would like to store the title and description of a
> product in different languages.  Should I use unicode
> (UTF-8) to store the different languages in one
> database, or I should initialize different databases
> for the different languages?

Administratively it is far easier to have everything in
one database. PostgreSQL can also convert between
Unicode and many local character sets (including
most CJK ones) on the fly.

However, PostgreSQL currently only enables one locale
per cluster (set of databases), so certain operations
(sorting "alphabetically" in a particular language) may
be tricky.


Ian Barwick
barwick@gmx.net