Author Topic: Cannot resolve collation conflict for equal to operation Err  (Read 219 times)

0 Members and 1 Guest are viewing this topic.

Offline h2obubbler

  • Full Member
  • *
  • Posts: 232
  • Karma: +0/-0
  • Life is like a box of chocolate.
    • View Profile
Cannot resolve collation conflict for equal to operation Err
« on: August 23, 2008, 05:25:17 PM »
I hope somebody is kind enough to help me out. Basically i am getting the following error in SQLServer2000..

Cannot resolve collation conflict for equal to operation

Sequence Of Operations which i did before the error occurred :
1. I tried to Restore a database from a SQLSERver7.0 backupfile into SQLServer2000 database

2. Differences found when the stored proc. \'sp_server_info\' was run on SQLSErver2000 and SQLServer7.0
Settings

IDENTIFIER_CASE
SQLSERver7.0 SENSITIVE
SQLServer2000 MIXED


COLLATION_SEQ
SQLSERver7.0 :- charset=iso_1 sort_order=bin_iso_1 charset_num=1 sort_order_num=50
SQLServer2000 :- charset=iso_1 sort_order=nocase_iso charset_num=1 sort_order_num=52


3. For the command "select DATABASEPROPERTYEX()" in SQLServer2000
The temporary and master database returns --> SQL_Latin1_General_CP1_CI_AS
The restored database returns --> Latin1_General_BIN

4. I got this error in a sp where data is being fetched from 2 temporary tables.
I suppose the backup database \'Collation\' has to match the Master & temdb \'Collation\'

Now my problem is that how do i change the \'Collation\' parameter of the new database so that it matches with the tempdb database ? Would this solve the problem I have ?

Many Thanks.

Techronnati | where technology never sleeps

Cannot resolve collation conflict for equal to operation Err
« on: August 23, 2008, 05:25:17 PM »

Mountain View

Offline JusticeLeague

  • Sr. Member
  • *
  • Posts: 365
  • Karma: +1/-0
    • View Profile
Re: Cannot resolve collation conflict for equal to operation Err
« Reply #1 on: August 23, 2008, 05:26:50 PM »
As i see it, Tempdb will use the collation of the model database when the server is started (i.e. tempdb is built).

Use can coerce the collations used in queries to compare using a specific collation.
= (colname collate collationname)

You can change the collation of a database by
alter database collate collationname
this will change the default collation for new tables
For existing ones I think you will have to run alter table scripts.

Offline MoneyRepublic

  • Full Member
  • *
  • Posts: 170
  • Karma: +0/-0
    • View Profile
Re: Cannot resolve collation conflict for equal to operation Err
« Reply #2 on: August 23, 2017, 11:05:56 AM »
Hi, i encountered this day error the other day, I think Justice league has a point, maybe you can try that one out.

 

Related Topics

  Subject / Started by Replies Last post
1 Replies
1473 Views
Last post October 28, 2016, 04:48:09 AM
by JusticeLeague
0 Replies
94 Views
Last post March 04, 2009, 09:41:38 AM
by MrSpecialist
2 Replies
196 Views
Last post August 08, 2014, 07:44:20 AM
by rpmolecule
1 Replies
60 Views
Last post July 21, 2016, 01:36:00 AM
by rpmolecule
0 Replies
244 Views
Last post September 05, 2016, 07:40:21 AM
by GBTalk

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.