SQL collation - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL collation

Author

Topic

ravehelp
Starting Member

1 Post

Posted - 2009-03-31 : 05:27:55

Hi All,

I am geting an error Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. with InterpriseSuiteECommerce'Application.
there is conflict between SQL server and Database collation.
Can I chage Server/Database collation and how to affect these change to my SQL server?.

how can i resolve that error please suggest.

Thanks&Regards
Lucky

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-03-31 : 05:30:02

You can change the collation for the statement only, if you need to.
Add the COLLATE keyword after the column and the collation name you want to use.

E 12°55'05.63"
N 56°04'39.26"

ahmad.osama
Posting Yak Master

183 Posts

Posted - 2009-04-16 : 11:08:37

quote:
Originally posted by ravehelp

Hi All,

I am geting an error Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. with InterpriseSuiteECommerce'Application.
there is conflict between SQL server and Database collation.
Can I chage Server/Database collation and how to affect these change to my SQL server?.

how can i resolve that error please suggest.

Thanks&Regards
Lucky

u can obviously change the server collation of server and database.


Alter database mydb COLLATE collationname.

however, u need to rebuild indexes n also u need to update the collationid of columns in sys.syscolumns table.


update syscolumns
set collationid = (select top 1 collationid from systypes where systypes.xtype=syscolumns.xtype)
where collationid <> (select top 1 collationid from systypes where systypes.xtype=syscolumns.xtype)

In order to update the server collation u need rebuild all the system database through command promt...
also, when the system databases are rebuild, user database are dropped...so u shud backup all ur user databases.

Regards,
Ahmad Osama

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources