Re: Multilingual database

Thanks for your idea.  What if I give every language a
table for title and description, and use the code as a
relation?  And one more table for the code, price and
photos.  Please criticize!

 --- "M. Bastin" <marcbastin@mindspring.com> wrote: >
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
>

_______________________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com.hk address at http://mail.english.yahoo.com.hk