Table Conflict

• mmatseke

  Ten Centuries

  Points: 1129

  More actions

  October 27, 2004 at 1:20 am

  #162534

  My Vendor created the table like this:

  CREATE TABLE TestTab (

     id int,

     GreekCol nvarchar(10) collate greek_ci_as,

     LatinCol nvarchar(10) collate latin1_general_cs_as

     )

  THEN I

  INSERT TestTab VALUES (1, N'A', N'a')

  GO

   

  PROBLEM when I

  SELECT *

  FROM TestTab

  WHERE GreekCol = LatinCol

  I get an Error

  Cannot resolve collation conflict for equal to operation

  I know I can solve this by doing this

  SELECT *

  FROM TestTab

  WHERE GreekCol = LatinCol COLLATE greek_ci_as

  QUESTION

  How do I change a table that was created like that to something the developers can use so that they don't have to go through this pain

   

• mmatseke

  Ten Centuries

  Points: 1129

  More actions

  October 27, 2004 at 2:39 am

  #528117

  I answered myself, for those who have the same problem, this is what you can do, alter a column so that the collations are the same

  ALTER TABLE TestTab ALTER COLUMN LatinCol nvarchar(10) collate greek_ci_as