Thread: multi-languages in a table

"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

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.