Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved due to a collation conflict RSS

• • Reply
  

  Kanchana1987

  Member

  12 Points

  49 Posts

  Implicit conversion of varchar value to varchar cannot be performed because the collation of the ...

  Jan 18, 2011 05:05 AM|LINK

  I have two database.one is "TEMS1" and another one is "TEMSLIVE"

  "TEMS1" is my local database.

  "TEMSLIVE" is client database.

  my application is working fine while connecting to my local database.

  when connecting to client database("TEMSLIVE")  it's shows "Msg 457, Level 16, State 1, Procedure GET_MY_TRAVEL_PENDING_ACTIONS, Line 53

  Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved due to a collation conflict." this error.

  i have compared "TEMS1" and "TEMSLIVE" stored procedure(GET_MY_TRAVEL_PENDING_ACTIONS),but both are identical only.

  please can any one help me.

  Thanks,

  Kanchana.

  
  

  
  

  
  

  
  

  • Moved by ignatandrei on Jan 18, 2011 06:13 AM
• • Reply
  

  krisrajz

  Participant

  1845 Points

  541 Posts

  Re: Implicit conversion of varchar value to varchar cannot be performed because the collation of ...

  Jan 18, 2011 06:20 AM|LINK

  Check individual fields too!

  All the best

  Regards
  
  Raj 

  Regards,
  Raj
  
  Remember to click Mark as Answer on the post that helps to others.
  
• • Reply
  

  jassu107

  Participant

  817 Points

  243 Posts

  Re: Implicit conversion of varchar value to varchar cannot be performed because the collation of ...

  Jan 18, 2011 06:38 AM|LINK

  http://blog.sqlauthority.com/2007/06/11/sql-server-cannot-resolve-collation-conflict-for-equal-to-operation/
  

  
  

  
  

  http://www.developmentnow.com/g/113_2006_7_0_0_797273/Cannot-resolve-collation-conflict-for-equal-to-operation-.htm
  

  ------------
  
  Mark as Answer if it helps you...
  • Edited by jassu107 on Jan 18, 2011 06:43 AM
• • Reply
  

  KumarHarsh

  All-Star

  15133 Points

  3647 Posts

  Re: Implicit conversion of varchar value to varchar cannot be performed because the collation of ...

  Jan 18, 2011 07:04 AM|LINK

  2 different collation causing the problem.
  

  http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/0d0a2659-edb5-4f22-b602-5db29e9b1c4d/

  http://www.sqlservercentral.com/Forums/Topic772463-338-1.aspx#bm772662

   

  Warm Regards
  Kumar Harsh