SQL Server Collation

myanilkumar

Hi,

I am Single Sql Server 2005 Instance having multiple databases. All the databases using default collation Latin1_General_CI_AI. Now i need to create One more database that uses Japanese Language. Is it possible On Single Instance we can use different Collations for different databases? Is there will be any issues? Please let me know.

Also Please let me know Which collation is used for Japanese Language?

Regards,
Anil

pdj

I doubt it will give any problems.
However; you should always be aware that the Master database (and the other system databases) are using the collation that was specified when the SQL server was installed. This collation is rather difficult to change, and basically requires a new installation.
This might influence your databases, because Users are stored in the Master database.

ara3n

Also if you are doing any queries across the databases you'll need to add collation translation in your queries.
It's quiet normal to have have databases with different collation.