April 2, 2002 at 8:39 am
I have SQl server 2000 with SERVER collation setting
SQL_Latin1_General_CP1_CI_AS.
I have 2 instances on this server, say instance1 and instance2.
Instance1 (which is a default instance)
has database testdb1 with collation setting
SQL_Latin1_General_CP1_CI_AI
Instance2 has database testdb2 with collation setting
SQL_Latin1_General_CP1_CI_AI
Both have same database copy ( no collation setting on the table level), when I try to insert a row in a table say legal with FRENCH ASCENTS, the value in testdb1
gets converted to plain english alphabets in other words I loose the FRENCH ASCENTS, where as I get the correct value in testdb2 (with French ascents), why ???
How do I know the collations setting for instance, is there any query I can run to find out the collation setting for instance or something else is causing this ?
thanks
Sonali
April 2, 2002 at 12:39 pm
Have you looked at the collation setting of the data columns? In SQL EM, right click on the tablename, select Design Table. Select/highlight the column containing the data. At the bottom of the window, is a 'Columns' tab and the last entry is the collation value for the highlighted field. If it says, <database default>, then it's the same collation that the database was created with.
Since data columns can have different collations than the database default, just thought this would be a good place to look first, to be sure that both fields in the different databases really have the same collation.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply