internationalization | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

internationalization

I need to find out more about what is needed to set up a SQL Server 2005 database for languages other than English (i.e. German, French, & Spanish). I have looked at the BOL and haven’t found much. Can someone provide some guidance as to where there might be some solid documentation for setting up databases in other languages? Does anyone have any advice? Many thanks.
You have to read collation in BOL. Example, in Spanish are the following possibilities: Accent Insensitive, case Insensitive. Or, Accent sensitive, case sensitive, etc.
All is about application. I suggest to talk with developers.
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
International Considerations for SQL Server http://msdn2.microsoft.com/en-us/library/ms142795.aspx ——————
Bug explorer/finder/seeker/locator
——————
quote:Originally posted by tkisling I need to find out more about what is needed to set up a SQL Server 2005 database for languages other than English (i.e. German, French, & Spanish). I have looked at the BOL and haven’t found much. Can someone provide some guidance as to where there might be some solid documentation for setting up databases in other languages? Does anyone have any advice? Many thanks.

Just type ‘INTERNATION’ in books online index you get everything… Here it is from Books online…
International Considerations for SQL Server
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/icsql9/html/50dc4fa8-4772-46a8-a8ef-bc134502b4e0.htm
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

Hope you will get with the above references, alsohttp://blogs.msdn.com/michkap/archive/2006/01/29/518777.aspx fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
thank you all for your replies. I do appreciate it.
We will appreciate if you can feedback what you have found, that will be useful for others with similar requirment. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Thanks to all who responded to my original post. I have found applicable information in BOL, particularly regarding what collation to use for different languages (German, French, and Spanish in our case). What I am still curious about is how index usage is impacted by the difference in collation by language. For example – with Oracle there is the ability to create and use linguistic indexes inherent to a given language. Does SQL Server have this capability? How am I to translate the current indexes I have in an English database and create the same behavior in a German, French, or Spanish db? Thanks.
]]>