Thread: multi-languages in a table

multi-languages in a table

From
"YL"
Date:
I'm migrating from mysql to postgresql.
I've several (mysql)tables with multi-language columns:
 
descript, descript_gb, descript_b5, descript_sp
 
they store the record's description in
English, SimplifiedChinese, TraditionalChinese and Spanish respectively.
 
I don't know if this will work in postgresql: I need to query those columns
(one language at a time). And I hope the contents in those columns
can be displayed in web (one language at a time) easily.
 
Any suggestions? Thanks

Re: multi-languages in a table

From
Douglas McNaught
Date:
"YL" <elim@pdtnetworks.net> writes:

> I'm migrating from mysql to postgresql.
> I've several (mysql)tables with multi-language columns:
>
> descript, descript_gb, descript_b5, descript_sp
>
> they store the record's description in
> English, SimplifiedChinese, TraditionalChinese and Spanish respectively.
>
> I don't know if this will work in postgresql: I need to query those
> columns
> (one language at a time). And I hope the contents in those columns
> can be displayed in web (one language at a time) easily.
>
> Any suggestions? Thanks

I don't think this will be a problem, as long as you use UNICODE
(UTF-8) for the database encoding.

-Doug

Re: multi-languages in a table

From
"mrix"
Date:
This may cause troubles to, because sorting is done using LC_COLLATE
value, whuch cannot be changed, and is set with initdb.
So please consider this  limitation before doing any changes.