Re: multi-languages in a table - Mailing list pgsql-general

From Douglas McNaught
Subject Re: multi-languages in a table
Date
Msg-id m28y11c526.fsf@Douglas-McNaughts-Powerbook.local
Whole thread Raw
In response to multi-languages in a table  ("YL" <elim@pdtnetworks.net>)
Responses Re: multi-languages in a table
List pgsql-general
"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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Corrupted index
Next
From: Michael Fuhr
Date:
Subject: Re: plpgsql and schema