| From: | Ian Barwick <barwick(at)gmx(dot)net> |
|---|---|
| To: | Terence Ng <ngterry2000(at)yahoo(dot)com(dot)hk>, admin pgsql <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Multilingual database |
| Date: | 2003-05-10 11:22:42 |
| Message-ID: | 200305101322.42425.barwick@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-novice |
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(at)gmx(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Randall Perry | 2003-05-10 18:36:16 | Re: Pg_hba and dynamic dns |
| Previous Message | Raymond Chan | 2003-05-10 01:50:49 | Re: Upgrade to RH9.....Help....PostgreSQL newbie |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Kershaw | 2003-05-10 23:20:54 | Help with pg_connect() command. |
| Previous Message | Sudhanshu Gupta | 2003-05-10 09:16:47 |