MySQL Forums
Forum List  »  Newbie

multi-language transalations
Posted by: screen mate
Date: July 22, 2005 07:44AM

For creating a multi-langauge app, which is the best appraoch:

a. add a languageId column to primray key
b. add multiple descrirption columns for each language

eg:

original table:
categoryId
description

primary-key approach:
categoryId
languageId
description

multiple description column approach:
categoryId
description_en
description_es
description_ar
description_fr
description_de
description_jp
description_cn
......
...

any better approachs? can give teh design for transalation tables?

thanks...

Options: ReplyQuote


Subject
Written By
Posted
multi-language transalations
July 22, 2005 07:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.