hi,
I'm building a multi-lingual website
In my database tables I have, in some of them, a column with the Language, because some of the columns depend on what language the user wants to see the site.
My question is: what is better? have that column and consequently two row (for two languages) with repeated column information? or have two column within a row with the language specification?
e.g.
table: id, description, price
(1) With language:
id,description, price, language='EX'
id,description, price, language='EN'
vs.
(2)
id, descriptionEN,descriptionEX,price
if I have 500 products
in 1 whould result in 1000 entries
in 2 just 500 results
can anyone tell me a diference/advantage between the two approachs?
thanks in advance.
In a problem like this, I would be guided by the following:
If the number of languages is fixed (i.e. the number of columns is not expected to change), go with the second approach (each language in a different field)
In case the number of languages can increase, go with the first approach as it gives you the flexibility to add another row for every new language.
