Thursday, August 09, 2012 4:25 PM
I have an Quotating Application in Visual Studio 2010 and Database in SQL Server 2008. Now I want to give multi language support for that project. I thought I have to change the master table schemas to support for multilanguage. What are the changes needed in database to support multilanguage. The client wants to increase the languages when they require. Please suggest me the optimal design of database to support multi language.
I gone through the below discussion
Friday, August 10, 2012 6:29 AMAnswerer
The columns where you store text in multi-languages you have to design as NVACHAR(n).That's all.
Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/
Friday, August 10, 2012 9:45 AM
Thanks for your reply. I already have an idea that we have to use NVACHAR(n) for Unicode but I want the database design for multi language support. I gone through your links but those methods are already I saw in below link.
Any other optimum solutions.
Sunday, August 12, 2012 9:25 AM
I support Uri's suggestion of using UNICODE columns (such as NVARCHAR) for multi-language support.
Is there a particular problem you're having with Unicode? Unless all the languages are latin-based (or any group that can fall within the same collation), I don't see any other way to achieve what you require.
Except, of course, create a separate table / column per each language, each in a different collation.
Eitan Blumin; SQL Server Consultant - Madeira SQL Server Services; http://www.madeira.co.il/author/eitan/
- Edited by EitanBlumin Sunday, August 12, 2012 9:26 AM
Monday, August 13, 2012 8:59 PM
And if this involves full text search as well, please follow the links found in the following discussion.