Truemag

  • Categories
    • Tips And Tricks
    • Internet
    • PHP
    • Javascript
    • CSharp
    • SQL Server
    • Linux
  • Lastest Videos
  • Our Demos
  • About
  • Contact
  • Home
  • Write With Us
  • Job Request
Home SQL Server SQL Server: Cannot resolve the collation conflict between in the equal to operation

SQL Server: Cannot resolve the collation conflict between in the equal to operation

We get MSSQL error message: “Cannot resolve the collation conflict between “SQL_Latin1_General_CP850_CI_AS” and “Latin1_General_CI_AS” in the equal to operation.” when run a SQL script. In order to fix the collation conflict in the equal to operation issue, we may need to add COLLATE DATABASE_DEFAULT clause to the right of column in the condition.

SQL Server Cannot resolve the collation conflict between in the equal to operation

SQL Server Cannot resolve the collation conflict between in the equal to operation

Example to fix the collation conflict in the equal to operation

Example 1

SELECT * FROM 
tbl_profiles p INNER JOIN 
tbl_membership_card mc ON p.member_id COLLATE DATABASE_DEFAULT = mc.member_id COLLATE DATABASE_DEFAULT

select * from tbl_profiles p inner join tbl_membership_card mc on p.member_id COLLATE DATABASE_DEFAULT = mc.member_id COLLATE DATABASE_DEFAULT

Example 2

SELECT * 
FROM tbl_profiles 
WHERE member_id IN
(
	SELECT member_id COLLATE DATABASE_DEFAULT
	FROM tbl_membership_card 
)

select * from tbl_profiles where member_id in ( select member_id COLLATE DATABASE_DEFAULT from tbl_membership_card )

Sep 15, 2014Hoan Huynh
Asp.net Gridview Simple ExampleJQuery Call Function To Parent And Children Div
You Might Also Like:
  • How To Track Website With Multiple Google Analytisc Accounts
  • Get Image Width Height With JQuery And JavaScript
  • Javascript Problem Set focus textbox on Firefox
  • Jquery checkbox checked
  • Javascript generate a random number using Math.random
  • Facebook Like Button And Recommend Button With fb:like, iframe and html5
  • Replace String With NText Or Text Data Type In MS SQL Server
  • JavaScript Detect Protocol (HTTP/ HTTPS) To Load Or Handle Accordingly
  • String To Upper Case In PHP, JavaScript And .Net (CSharp)
  • String To Lower Case In PHP, JavaScript And .Net (CSharp)
Hoan Huynh

Hoan Huynh is the founder and head of 4rapiddev.com. Reach him at [email protected]

7 years ago SQL ServerDATABASE_DEFAULT, Latin1_General_CI_AS, SQL_Latin1_General_CP850_CI_AS3,665
0
GooglePlus
0
Facebook
0
Twitter
0
Digg
0
Delicious
0
Stumbleupon
0
Linkedin
0
Pinterest
Most Viewed
PHP Download Image Or File From URL
24,542 views
Notepad Plus Plus Compare Plugin
How To Install Compare Text Plugin In Notepad Plus Plus
21,885 views
Microsoft SQL Server 2008 Attach Remove Log
Delete, Shrink, Eliminate Transaction Log .LDF File
17,736 views
JQuery Allow only numeric characters or only alphabet characters in textbox
15,059 views
C# Read Json From URL And Parse/Deserialize Json
11,789 views
4 Rapid Development is a central page that is targeted at newbie and professional programmers, database administrators, system admin, web masters and bloggers.
Recent Posts
  • Things to Learn about Installingderm Loan Type S
  • Online Photo Editor – Free Photoediting Software
  • A Guide to Finding the Best Paper Sellers
  • Photoediting in Home Isn’t Hard to Do!

  • Free Photo Editor Online
Categories
  • CSharp (45)
  • Facebook Graph API (19)
  • Google API (7)
  • Internet (87)
  • iPhone XCode (8)
  • Javascript (35)
  • Linux (27)
  • MySQL (16)
  • PHP (84)
  • Problem Issue Error (29)
  • Resources (32)
  • SQL Server (25)
  • Timeline (5)
  • Tips And Tricks (141)
  • Uncategorized (647)
Recommended
  • Custom Software Development Company
  • Online Useful Tools
  • Premium Themes
  • VPS
2014 © 4 Rapid Development