October 4, 2005 at 10:14 am
When I try to get this result from 2 tables inner join: (case when so.dispname is null then r.url else left(so.dispname, 50) end) source, where so.dispname is varchar(255) and r.url is varchar(50) I've got this error: Implicit conversion of %ls value to %ls cannot be performed because the collation of the value is unresolved due to a collation conflict. Both columns (dispname and url) have same collation option- database default. What is the reason for this error? Thanks
October 4, 2005 at 10:16 am
Are those tables in the same db?
Do the tables have the same collations?
October 4, 2005 at 10:24 am
Yes, tables are in the same DB. I don't know how to check table collation but columns collations as I pointed are the same- default DB. Thanks
October 4, 2005 at 10:55 am
Right click in the object browser in the Query Analyzer to generate the create table statement, it includes the collation. The error could be because you are doing column level collation which means you have to do alter to make them compatible. Run a search for examples of SQL collations in the BOL (books online). Hope this helps
Kind regards,
Gift Peddie
Kind regards,
Gift Peddie
October 4, 2005 at 11:24 am
Could you post the tables DDL and the full sql statement? Maybe we'll spot the problem.
November 20, 2008 at 6:33 am
Pls Use this it will solve yr problem
ISNULL(CAST (surname AS VARCHAR) COLLATE SQL_Latin1_General_CP1_CI_AS,'')
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply