Multilanguage content in MS SQL database

  • Thread starter Thread starter deepakshar1987
  • Start date Start date
D

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
 
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 ?
Click to expand...

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?
 
Back
Top