Differences between Character Sets

[appi]

Hi all,

I need to know the impact if we have differences in the character set for sorting between Latin1_general_cp1_CI_AS or Latin1_general_CI_AS.

Will this have any impact on a running ssystem or a second Instance in one server ?

kind regards
uwe

 

[mrdenny]

There sholdn't be any sorting differences between those two. They are both using case-insensitive and Accent-Sensitive.

SQL Instances are totally independant of each other. Settings in one do not effect the settings of another weither they are on the same server or another server.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[appi]

Thanks Denny,

this helps much. I hoped for this and now I hope to get the Instances running as mentiend from the supplier.

regards
uwe