none
storing data of multi language master information in database RRS feed

  • Question

  •  

    Hello,

    I have an application in .Net which is need to be build in multiple language. The static data we are handling as sattelite application, but we need to store master information in database for each language. Say I have "Customer" table, and I need to store those data in database. What would be the best approach to store it in optimal way in terms of performance.

     

    Friday, November 16, 2007 5:00 AM

Answers

  • You have the option to either use a table per language for small application or database per language for big application.  You use Nvarchar/Nvarchar(max) data type and use the collation of each language per database, table, columns and in DML as needed.  The link below covers most of the info you need.  Hope this helps.

     

     

    http://msdn2.microsoft.com/en-us/library/ms143508.aspx

     

    Friday, November 16, 2007 4:44 PM