multi-language translations

[screenmates]

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?

 

[bendep]

i've uploaded my solution in this thread:

http://pfc.codexchange.sybase.com/issues/show_bug.cgi?id=21

feel free to adapt, based on the dataobject, you'll be able to find out what tables & columns to define.
good luck,

Ben