Best Practices to Design multi-language web site database

Question

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.

Answer 1

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.

Answer 2

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.