Different DB collation causing problems? 1

[Ovatvvon]

Hi,

I have a client from Taiwan who requires a database collation of Chinese_Taiwoan_Stroke_CI_AS. I know everything should be fine internally with the database if I make this setting, even if the SQL Server Instance that it is installed on has a collation of SQL_Latin1_General_CP1_CI_AI; however, I'm wondering if any complications could come into play in other areas, such as if they interact with TempDB or anything else I may not be thinking of, where a collation that is different from the SQL Instance that it resides on could cause problems.

Does anyone know if any problems could arise anywhere, which would instead urge us to just install a separate SQL instance with that collation?


-Ovatvvon :-Q

 

[ptheriault]

Ovatvvon,
You can change the collation right down to the column level in a table if you had to. At my last job I had internation web sites databases hosted from the same SQL server and all of the databases had different collations. I never had any major problems. The only time I have run into problems is when I have had to export the data into another database for use by another application.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[Ovatvvon]

I think my biggest concern was if they do any work with Temp tables, that the default collation would be different in the TempDB, and it wouldn't be able to handle the Traditional and Simplified Chinese character sets, and would cause problems, especially if any comparisons occurred. (I don't know at this point if they'll be doing work on the U.S. server or not, or only want it as read-only data. Still collecting information at this point).

So because the collations between the database in Taiwan and here will be the same, I should not expect any problems in the replication, correct?


-Ovatvvon :-Q

 

[ptheriault]

That is correct. I wouldn't expect for you to run into any problems.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[Ovatvvon]

Sounds good. Thanks!

-Ovatvvon :-Q