Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Multiple Languages - Static Text

Author  Topic 

medtech26
Posting Yak Master

169 Posts

Posted - 2007-12-31 : 16:03:56
Hello,

I'm currently developing a multi-lingual site (starting with 8 languages) and didn't decide as of how to design data structure for the "static" text (titles, headers etc.). I do however have couple of ideas and in need for an advise to help me choose wisely.

Option I: Create a table with two columns for each language (id,value).
Option II: Create one table with three columns (id,value,lng).

Keep in mind (if matters) that this is very small amount of data (about 150 records).

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-31 : 23:09:48
Option II sounds easy to handle, maybe wrong since don't know your whole thing.
Go to Top of Page
   

- Advertisement -