Re: Multilingual database

Use two tables (all in UTF8, if you're sure your front-end handles
this), the first holding the general product information like code
and price, and then the other one holding a record for each language,
with the code (as a relation to the other table with general
information), the language, and the description in that language.

At 10:48 AM +0800 5/10/03, 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? I appreciate if someone
>can give me some suggestions and what I should aware
>of. I have use the keyword "multilingual" to search
>the achrieves but cannot find an answer.
>
>Terence
>
>_________________________________________________________
>ëÊìÒê¢(é"˪ñN)ÅCèKäµé½ú–(óeëcôZ)ÅCåZñÖ(í¬öÛêv)...
>Yahoo! óȓþâ†çŽ
>http://ringtone.yahoo.com.hk
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faqs/FAQ.html