Multilanguage content in MS SQL database

[deepakshar1987]

Hi

What would be the best approach to handle a multi-language content in MsSql database ?

Basically, Let's say we have a website with some products and we have our database all information in english. Now, we would like to put different language information for different language-sites. So, what should be the optimized way to deal with it ?

Thanks

 

[Arne Vajhøj]

What would be the best approach to handle a multi-language content in
MsSql database ?

Basically, Let's say we have a website with some products and we have
our database all information in english. Now, we would like to put
different language information for different language-sites. So, what
should be the optimized way to deal with it ?

Typical you would do something like:

product
-------
id, PK
size
weight

product_description
-------------------

product_id, shared PK, FK->product
language, shared PK
description

Arne

PS: Where does C# get into the picture?