sql server - SqlServer - Specify a code page on data -

data come odbc. code page different between sqlserver database , odbc data.

the odbc data don't specify original code page , sqlserver interpret him default code page.

version : microsoft sql server 2008 r2 (sp1) - 10.50.2500.0 (x64)

for example :

select cast(cast('é' collate sql_latin1_general_cp850_bin2 varbinary(10)) varchar(10))    

returns ','

select cast(cast('é' collate sql_latin1_general_cp1_ci_as varbinary(10)) varchar(10))   

returns 'é'

how can specify original code page in query?

edit : nvarchar don't work, result empty string.

select cast(cast('é' collate sql_latin1_general_cp850_bin2 varbinary(10)) nvarchar(10)) 

re-edit : specify nvarchar in odbc query :

select reference openrowset('msdasql', 'dsn=***', 'select cast(reference nvarchar) reference orders') tmp 

this query return error message :

 [odbc engine interface]invalid column type: nvarchar.