Collation Conflict

Question

Post reply

Collation Conflict

zombi

SSCrazy

Points: 2605
More actions
August 23, 2009 at 10:55 pm

#225399

Hi Guys,
I have got a SQL server 2005 64 bit installed with a "Latin1_General_CI_AS" collation and I have migrated databases from another SQL server 2005 32 bit with collation "SQL_Latin1_General_CP1_CI_AS". There is no problem happening at the moment but i wanted to know can this create any issues? Any links or information will be appreciated. Thanks you very much in advance.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

free_mascot One Orange Chip Points: 27169 More actions · Answer 1

Zombi,

Here is the link for your reference:

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1241693,00.html

If you are successfully migrating... make sure to run DBCC commands to check data consistancy and Rebuild the indexes.

HTH

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

zombi SSCrazy Points: 2605 More actions · Answer 2

Thanks for your reply. I think i have to be more specific about my question? I don't have a problem in migrating databases. I have finished everything and everything is working like a charm. I just noticed that SQL server collation is different than the migrated server. so I thought if anyone has get into this situation and had any problems?

homebrew01 SSC Guru Points: 55548 More actions · Answer 3

I think one issue can be when using temp tables in Tempdb that join to tables in other databases. Since they will have different collations you may have to put "collate" satements in your JOINs

free_mascot One Orange Chip Points: 27169 More actions · Answer 4

Hello Zombi,

Thank you for more clarification and making your question understand 🙂

As far as I know there should not be any problem unless and untill you are using ENGLISH language for your database. But still if you need some more clarity kindly visit following link:

http://msdn.microsoft.com/en-us/library/ms143726(SQL.90).aspx

HTH

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

free_mascot One Orange Chip Points: 27169 More actions · Answer 5

Hello Zombi,

Thank you for more clarification and making your question understand 🙂

As far as I know there should not be any problem unless and untill you are using ENGLISH language for your database. But still if you need some more clarity kindly visit following link:

http://msdn.microsoft.com/en-us/library/ms143726(SQL.90).aspx

HTH

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

panwar.jt Default port Points: 1418 More actions · Answer 6

Yes

U will face collation error when u will create a temp table and join that table with yur Db Table.

I just change collation of My database due to this error.

To change collation U have to drop all type of constraints view, computed column and regenerate again.

Thnaks

KD