Click here to Skip to main content
15,892,809 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi all,

I want to learn how to set Collation for sql server 2008 database which should support the multiple languages.

In my case, I want to support the following languages...

Name of Language, Sql server Collation
german		Latin1_General_CI_AS
english		Latin1_General_CI_AS
arabic		Arabic_CI_AS
polish		Polish_CI_AS
russian		Cyrillic_General_CI_AS
turkish		Turkish_CI_AS
vietnamese	Vietnamese_CI_AS
serbo-croatian	Croatian_CI_AS
spanish		Modern_Spanish_CI_AS
czech		Czech_CI_AS
romanian 	Romanian_CI_AS


I search on google and find the collation for the languages. but many of the languages in the list have different collation.
My question is
1. Is there any way to set the collation that should support all this languages
2. How can we set multiple collation for a single database.[i.e. multiple languages support in database]
3. What is the alternate way to support all this languages for sql database

My requirement is argent,
pls help me

Thanks...
Posted
Updated 22-Mar-12 1:27am
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900