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.
| Author |
Topic |
|
majedhazza
Starting Member
1 Post |
 Posted - 2012-02-06 : 13:04:32
|
| cannot resolve collation conflict between sql_latin1_general_cp1_ci_as and sql_latin1_general_cp1256_ci_as |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-02-06 : 13:14:19
|
| Force the collation to one or the other, or to something else - for example the database default. There are a few examples here: http://blog.sqlauthority.com/2007/06/11/sql-server-cannot-resolve-collation-conflict-for-equal-to-operation/ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-06 : 13:35:13
|
| just use COLLATE databse_default on both sides of comparison statement------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
resolve collation conflict in sql 2005