"YL" <elim(at)pdtnetworks(dot)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