CODEWITHSUNDEEP
database-design
Yoann. B
Yoann. B

Reputation: 11143

Best Practices to Design multi-language web site database

Best Practices to design multi-language web site database.

Technologies employed here are ASP.NET MVC and SQL Server.

EDIT :

I'm looking for table structure and relationship design.

Upvotes: 0

Views: 1517

Answers (2)

Greg Roberts
Greg Roberts

Reputation: 2562

What you are looking for is described in detail at http://www.west-wind.com/presentations/wwDbResourceProvider/. This shows you how to create a custom resource provider with Admin UI that stores the data in Sql.

Upvotes: 0

Oded
Oded

Reputation: 499002

On the DB side, use unicode (nvarchar and nchar) for your text.

Have a locale lookup table (containing the locale info you need - i.e. decimal point format), and for each table that has localized data add a foreign key to it.

Edit: (following comments)

Best practice is to use resource files for localization.

Upvotes: 2

Related Questions