Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Indexes in other languages

Author  Topic 

tkisling
Starting Member

1 Post

Posted - 2007-09-17 : 14:56:50
I need to create databases in other languages (ie French, German, Spanish). Basically what I have learned all that needs to be modified from my current English DDL is the collation.

My question is regarding indexes in these other languages. Will indexes that I currently have in English work in French, German, or Spanish as long as I have the correct collation set at the database level?

Kristen
Test

22859 Posts

Posted - 2007-09-17 : 15:06:36
Yes.

Note that the "Latin" collation may well be sufficient for European languages as it supports most accents and language-specific characters. That might be less effort than adopting language-specific collations, but worth checking carefully first of course!

Kristen
Go to Top of Page
   

- Advertisement -