3

I want to copy data from a table to another which has a different collation.

But when I execute my query, it returns an error. 

INSERT INTO [des].[dbo].TableDes
    SELECT *
    FROM [src].[dbo].TableSrc

Msg 468, Level 16, State 9, Line 1
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Arabic_CI_AS" in the equal to operation.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Mahdi H
  • 45
  • 1
  • 1
  • 9

1 Answers1

2

we have to define COLLATION when we move data one COLLATION to another

INSERT  INTO [des].[dbo].TableDes 
SELECT  col1,col2,... COLLATE Arabic_CI_AS
FROM    [src].[dbo].TableSrc

COLLATION

wiretext
  • 3,302
  • 14
  • 19
  • tinka I did it but accur same error... Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Arabic_CI_AS" in the equal to operation. – Mahdi H Aug 26 '15 at 10:22
  • 1
    @MahdiH it is working on my machine and this is also `COLLATE SQL_Latin1_General_CP1_CI_AS` – wiretext Aug 26 '15 at 11:00