Compare Unicode and non-unicode on a WHERE clause

• calico-604598

  Right there with Babe

  Points: 730

  More actions

  December 22, 2009 at 7:45 pm

  #207670

  Hi,

  is it possible to compare an Unicode column with a Non-unicode column into a where clause ? Does SQLServer is going to execute the implicite convert ?

  select

  ....

  WHERE table1.unicode_col = table2.non_unicode_col

  Can you give me the URL from the BOL where I can find the answer ?

  Thank you

  calico

• dmoldovan

  SSCertifiable

  Points: 6334

  More actions

  December 23, 2009 at 12:50 am

  #1095818

  See BOL ---> Collation Precedence