Hi,
My site (ASP.Net & SQL Server on same host) will display data depending on the language of the user (basically English & Japanese for now).
Most text on the pages will be hardcoded. No problem there.
But some entries I will store in the database will need to have their value stored in both languages. So I came up with the following ideas:
1)Create a lookup table with columns ID, English, Japanese, and link tables like say Company (with tables ID, TranslationID) on the ID and TranslationID fields.
Here I'm worried all the constant lookups will reduce performance.
Other ideas like using an XML alongside my web application, and so on came to my mind. Or in each table (say Companies) have colums like "EnglishName", "JapaneseName", etc. But this is not very scalable of course.
What do you guys use? What is the "normal" way. I never did this before.
Thanks in advance.
S
My site (ASP.Net & SQL Server on same host) will display data depending on the language of the user (basically English & Japanese for now).
Most text on the pages will be hardcoded. No problem there.
But some entries I will store in the database will need to have their value stored in both languages. So I came up with the following ideas:
1)Create a lookup table with columns ID, English, Japanese, and link tables like say Company (with tables ID, TranslationID) on the ID and TranslationID fields.
Here I'm worried all the constant lookups will reduce performance.
Other ideas like using an XML alongside my web application, and so on came to my mind. Or in each table (say Companies) have colums like "EnglishName", "JapaneseName", etc. But this is not very scalable of course.
What do you guys use? What is the "normal" way. I never did this before.
Thanks in advance.
S