October 7, 2014 at 1:05 pm
Hello
I am calling function through Linked server and it returns different values when i select as a variable,
see below
Select * from Openquery([AAA],'select [STARS].[dbo].[func_ConvertText](''abcd'')')
declare @blah varchar(100)
set @blah=(select * from Openquery([AAA],'select [STARS].[dbo].[func_ConvertText](''abcd'')'))
select @blah
this gives me output of
¨ª¥³
"ª¥3
This looks very strange to me, if anybody know, please let me know.
Thanks
October 7, 2014 at 1:06 pm
1. please post the different results
2. is it possible that the remote table was updated between the two queries?
Gerald Britton, Pluralsight courses
October 7, 2014 at 1:09 pm
g.britton (10/7/2014)
1. please post the different results2. is it possible that the remote table was updated between the two queries?
Hi
Thanks for Quick reply.
I posted outputs.
Thats not a table, thats function and its static.
October 7, 2014 at 1:14 pm
Sorry, I missed the output on the first read.
Can you post the function? I'm wondering if it returns NVARCHAR and the problem you're seeing is in converting it to VARCHAR
Gerald Britton, Pluralsight courses
October 7, 2014 at 1:18 pm
g.britton (10/7/2014)
Sorry, I missed the output on the first read.Can you post the function? I'm wondering if it returns NVARCHAR and the problem you're seeing is in converting it to VARCHAR
I checked function return value Data Type is Varchar(50)
One strange thing I ran same query against master or other database, it returns same value, but the one i need to run against return different. what do you think, is it database collation issue?
October 7, 2014 at 1:25 pm
COLLATION! That's a likely suspect. Can you find the collation of the databases where it works and compare it to those where it doesn't?
Gerald Britton, Pluralsight courses
October 7, 2014 at 1:28 pm
g.britton (10/7/2014)
COLLATION! That's a likely suspect. Can you find the collation of the databases where it works and compare it to those where it doesn't?
works
Latin1_General_BIN - - - SQL_Latin1_General_CP1_CI_AS
SQL_Latin1_General_CP1_CI_AS - - - SQL_Latin1_General_CP1_CI_AS
don't work
SQL_Latin1_General_CP437_BIN - - - SQL_Latin1_General_CP1_CI_AS
October 7, 2014 at 1:33 pm
You can also specify collation when you set the variable, e.g.
set @Foo = 'bar' COLLATE Latin1_General_CS_AS_KS_WS
Gerald Britton, Pluralsight courses
October 7, 2014 at 1:39 pm
g.britton (10/7/2014)
You can also specify collation when you set the variable, e.g.
set @Foo = 'bar' COLLATE Latin1_General_CS_AS_KS_WS
I try as below
Select * from Openquery([AAA],'select [STARS].[dbo].[func_ConvertText](''abcd'')')
declare @blah varchar(100)
set @blah=(select * from Openquery([AAA],'select [STARS].[dbo].[func_ConvertText](''abcd'')COLLATE SQL_Latin1_General_CP1_CI_AS'))
select @blah
but same result
October 7, 2014 at 1:57 pm
fwiw I tried your text with all available collations. Results below.
SQL_Latin1_General_CP437_BIN produced the results where you set it to a variable
query to do it:
declare @Foo varchar(100)
set @Foo = '¨ª¥³'
declare cur cursor for
select name from sys.fn_helpcollations() --where name like 'ch%'
open cur
declare @coll nvarchar(256)
declare @sql nvarchar(512)
fetch next from cur into @coll
--print @coll
while @@fetch_status = 0 begin
print @coll
set @sql = 'print ''' + @Foo + ''' COLLATE ' + @coll
--print @sql
exec (@sql)
fetch next from cur into @coll
end
close cur
deallocate cur
[/code
Albanian_BIN
¨aY3
Albanian_BIN2
¨aY3
Albanian_CI_AI
¨aY3
Albanian_CI_AI_WS
¨aY3
Albanian_CI_AI_KS
¨aY3
Albanian_CI_AI_KS_WS
¨aY3
Albanian_CI_AS
¨aY3
Albanian_CI_AS_WS
¨aY3
Albanian_CI_AS_KS
¨aY3
Albanian_CI_AS_KS_WS
¨aY3
Albanian_CS_AI
¨aY3
Albanian_CS_AI_WS
¨aY3
Albanian_CS_AI_KS
¨aY3
Albanian_CS_AI_KS_WS
¨aY3
Albanian_CS_AS
¨aY3
Albanian_CS_AS_WS
¨aY3
Albanian_CS_AS_KS
¨aY3
Albanian_CS_AS_KS_WS
¨aY3
Arabic_BIN
¨?¥³
Arabic_BIN2
¨?¥³
Arabic_CI_AI
¨?¥³
Arabic_CI_AI_WS
¨?¥³
Arabic_CI_AI_KS
¨?¥³
Arabic_CI_AI_KS_WS
¨?¥³
Arabic_CI_AS
¨?¥³
Arabic_CI_AS_WS
¨?¥³
Arabic_CI_AS_KS
¨?¥³
Arabic_CI_AS_KS_WS
¨?¥³
Arabic_CS_AI
¨?¥³
Arabic_CS_AI_WS
¨?¥³
Arabic_CS_AI_KS
¨?¥³
Arabic_CS_AI_KS_WS
¨?¥³
Arabic_CS_AS
¨?¥³
Arabic_CS_AS_WS
¨?¥³
Arabic_CS_AS_KS
¨?¥³
Arabic_CS_AS_KS_WS
¨?¥³
Azeri_Cyrillic_90_BIN
????
Azeri_Cyrillic_90_BIN2
????
Azeri_Cyrillic_90_CI_AI
????
Azeri_Cyrillic_90_CI_AI_WS
????
Azeri_Cyrillic_90_CI_AI_KS
????
Azeri_Cyrillic_90_CI_AI_KS_WS
????
Azeri_Cyrillic_90_CI_AS
????
Azeri_Cyrillic_90_CI_AS_WS
????
Azeri_Cyrillic_90_CI_AS_KS
????
Azeri_Cyrillic_90_CI_AS_KS_WS
????
Azeri_Cyrillic_90_CS_AI
????
Azeri_Cyrillic_90_CS_AI_WS
????
Azeri_Cyrillic_90_CS_AI_KS
????
Azeri_Cyrillic_90_CS_AI_KS_WS
????
Azeri_Cyrillic_90_CS_AS
????
Azeri_Cyrillic_90_CS_AS_WS
????
Azeri_Cyrillic_90_CS_AS_KS
????
Azeri_Cyrillic_90_CS_AS_KS_WS
????
Azeri_Latin_90_BIN
¨ª¥³
Azeri_Latin_90_BIN2
¨ª¥³
Azeri_Latin_90_CI_AI
¨ª¥³
Azeri_Latin_90_CI_AI_WS
¨ª¥³
Azeri_Latin_90_CI_AI_KS
¨ª¥³
Azeri_Latin_90_CI_AI_KS_WS
¨ª¥³
Azeri_Latin_90_CI_AS
¨ª¥³
Azeri_Latin_90_CI_AS_WS
¨ª¥³
Azeri_Latin_90_CI_AS_KS
¨ª¥³
Azeri_Latin_90_CI_AS_KS_WS
¨ª¥³
Azeri_Latin_90_CS_AI
¨ª¥³
Azeri_Latin_90_CS_AI_WS
¨ª¥³
Azeri_Latin_90_CS_AI_KS
¨ª¥³
Azeri_Latin_90_CS_AI_KS_WS
¨ª¥³
Azeri_Latin_90_CS_AS
¨ª¥³
Azeri_Latin_90_CS_AS_WS
¨ª¥³
Azeri_Latin_90_CS_AS_KS
¨ª¥³
Azeri_Latin_90_CS_AS_KS_WS
¨ª¥³
Chinese_Hong_Kong_Stroke_90_BIN
?a
Chinese_Hong_Kong_Stroke_90_BIN2
?a
Chinese_Hong_Kong_Stroke_90_CI_AI
?a
Chinese_Hong_Kong_Stroke_90_CI_AI_WS
?a
Chinese_Hong_Kong_Stroke_90_CI_AI_KS
?a
Chinese_Hong_Kong_Stroke_90_CI_AI_KS_WS
?a
Chinese_Hong_Kong_Stroke_90_CI_AS
?a
Chinese_Hong_Kong_Stroke_90_CI_AS_WS
?a
Chinese_Hong_Kong_Stroke_90_CI_AS_KS
?a
Chinese_Hong_Kong_Stroke_90_CI_AS_KS_WS
?a
Chinese_Hong_Kong_Stroke_90_CS_AI
?a
Chinese_Hong_Kong_Stroke_90_CS_AI_WS
?a
Chinese_Hong_Kong_Stroke_90_CS_AI_KS
?a
Chinese_Hong_Kong_Stroke_90_CS_AI_KS_WS
?a
Chinese_Hong_Kong_Stroke_90_CS_AS
?a
Chinese_Hong_Kong_Stroke_90_CS_AS_WS
?a
Chinese_Hong_Kong_Stroke_90_CS_AS_KS
?a
Chinese_Hong_Kong_Stroke_90_CS_AS_KS_WS
?a
Chinese_PRC_BIN
¨a
Chinese_PRC_BIN2
¨a
Chinese_PRC_CI_AI
¨a
Chinese_PRC_CI_AI_WS
¨a
Chinese_PRC_CI_AI_KS
¨a
Chinese_PRC_CI_AI_KS_WS
¨a
Chinese_PRC_CI_AS
¨a
Chinese_PRC_CI_AS_WS
¨a
Chinese_PRC_CI_AS_KS
¨a
Chinese_PRC_CI_AS_KS_WS
¨a
Chinese_PRC_CS_AI
¨a
Chinese_PRC_CS_AI_WS
¨a
Chinese_PRC_CS_AI_KS
¨a
Chinese_PRC_CS_AI_KS_WS
¨a
Chinese_PRC_CS_AS
¨a
Chinese_PRC_CS_AS_WS
¨a
Chinese_PRC_CS_AS_KS
¨a
Chinese_PRC_CS_AS_KS_WS
¨a
Chinese_PRC_90_BIN
¨a
Chinese_PRC_90_BIN2
¨a
Chinese_PRC_90_CI_AI
¨a
Chinese_PRC_90_CI_AI_WS
¨a
Chinese_PRC_90_CI_AI_KS
¨a
Chinese_PRC_90_CI_AI_KS_WS
¨a
Chinese_PRC_90_CI_AS
¨a
Chinese_PRC_90_CI_AS_WS
¨a
Chinese_PRC_90_CI_AS_KS
¨a
Chinese_PRC_90_CI_AS_KS_WS
¨a
Chinese_PRC_90_CS_AI
¨a
Chinese_PRC_90_CS_AI_WS
¨a
Chinese_PRC_90_CS_AI_KS
¨a
Chinese_PRC_90_CS_AI_KS_WS
¨a
Chinese_PRC_90_CS_AS
¨a
Chinese_PRC_90_CS_AS_WS
¨a
Chinese_PRC_90_CS_AS_KS
¨a
Chinese_PRC_90_CS_AS_KS_WS
¨a
Chinese_PRC_Stroke_BIN
¨a
Chinese_PRC_Stroke_BIN2
¨a
Chinese_PRC_Stroke_CI_AI
¨a
Chinese_PRC_Stroke_CI_AI_WS
¨a
Chinese_PRC_Stroke_CI_AI_KS
¨a
Chinese_PRC_Stroke_CI_AI_KS_WS
¨a
Chinese_PRC_Stroke_CI_AS
¨a
Chinese_PRC_Stroke_CI_AS_WS
¨a
Chinese_PRC_Stroke_CI_AS_KS
¨a
Chinese_PRC_Stroke_CI_AS_KS_WS
¨a
Chinese_PRC_Stroke_CS_AI
¨a
Chinese_PRC_Stroke_CS_AI_WS
¨a
Chinese_PRC_Stroke_CS_AI_KS
¨a
Chinese_PRC_Stroke_CS_AI_KS_WS
¨a
Chinese_PRC_Stroke_CS_AS
¨a
Chinese_PRC_Stroke_CS_AS_WS
¨a
Chinese_PRC_Stroke_CS_AS_KS
¨a
Chinese_PRC_Stroke_CS_AS_KS_WS
¨a
Chinese_PRC_Stroke_90_BIN
¨a
Chinese_PRC_Stroke_90_BIN2
¨a
Chinese_PRC_Stroke_90_CI_AI
¨a
Chinese_PRC_Stroke_90_CI_AI_WS
¨a
Chinese_PRC_Stroke_90_CI_AI_KS
¨a
Chinese_PRC_Stroke_90_CI_AI_KS_WS
¨a
Chinese_PRC_Stroke_90_CI_AS
¨a
Chinese_PRC_Stroke_90_CI_AS_WS
¨a
Chinese_PRC_Stroke_90_CI_AS_KS
¨a
Chinese_PRC_Stroke_90_CI_AS_KS_WS
¨a
Chinese_PRC_Stroke_90_CS_AI
¨a
Chinese_PRC_Stroke_90_CS_AI_WS
¨a
Chinese_PRC_Stroke_90_CS_AI_KS
¨a
Chinese_PRC_Stroke_90_CS_AI_KS_WS
¨a
Chinese_PRC_Stroke_90_CS_AS
¨a
Chinese_PRC_Stroke_90_CS_AS_WS
¨a
Chinese_PRC_Stroke_90_CS_AS_KS
¨a
Chinese_PRC_Stroke_90_CS_AS_KS_WS
¨a
Chinese_Taiwan_Bopomofo_BIN
?a
Chinese_Taiwan_Bopomofo_BIN2
?a
Chinese_Taiwan_Bopomofo_CI_AI
?a
Chinese_Taiwan_Bopomofo_CI_AI_WS
?a
Chinese_Taiwan_Bopomofo_CI_AI_KS
?a
Chinese_Taiwan_Bopomofo_CI_AI_KS_WS
?a
Chinese_Taiwan_Bopomofo_CI_AS
?a
Chinese_Taiwan_Bopomofo_CI_AS_WS
?a
Chinese_Taiwan_Bopomofo_CI_AS_KS
?a
Chinese_Taiwan_Bopomofo_CI_AS_KS_WS
?a
Chinese_Taiwan_Bopomofo_CS_AI
?a
Chinese_Taiwan_Bopomofo_CS_AI_WS
?a
Chinese_Taiwan_Bopomofo_CS_AI_KS
?a
Chinese_Taiwan_Bopomofo_CS_AI_KS_WS
?a
Chinese_Taiwan_Bopomofo_CS_AS
?a
Chinese_Taiwan_Bopomofo_CS_AS_WS
?a
Chinese_Taiwan_Bopomofo_CS_AS_KS
?a
Chinese_Taiwan_Bopomofo_CS_AS_KS_WS
?a
Chinese_Taiwan_Bopomofo_90_BIN
?a
Chinese_Taiwan_Bopomofo_90_BIN2
?a
Chinese_Taiwan_Bopomofo_90_CI_AI
?a
Chinese_Taiwan_Bopomofo_90_CI_AI_WS
?a
Chinese_Taiwan_Bopomofo_90_CI_AI_KS
?a
Chinese_Taiwan_Bopomofo_90_CI_AI_KS_WS
?a
Chinese_Taiwan_Bopomofo_90_CI_AS
?a
Chinese_Taiwan_Bopomofo_90_CI_AS_WS
?a
Chinese_Taiwan_Bopomofo_90_CI_AS_KS
?a
Chinese_Taiwan_Bopomofo_90_CI_AS_KS_WS
?a
Chinese_Taiwan_Bopomofo_90_CS_AI
?a
Chinese_Taiwan_Bopomofo_90_CS_AI_WS
?a
Chinese_Taiwan_Bopomofo_90_CS_AI_KS
?a
Chinese_Taiwan_Bopomofo_90_CS_AI_KS_WS
?a
Chinese_Taiwan_Bopomofo_90_CS_AS
?a
Chinese_Taiwan_Bopomofo_90_CS_AS_WS
?a
Chinese_Taiwan_Bopomofo_90_CS_AS_KS
?a
Chinese_Taiwan_Bopomofo_90_CS_AS_KS_WS
?a
Chinese_Taiwan_Stroke_BIN
?a
Chinese_Taiwan_Stroke_BIN2
?a
Chinese_Taiwan_Stroke_CI_AI
?a
Chinese_Taiwan_Stroke_CI_AI_WS
?a
Chinese_Taiwan_Stroke_CI_AI_KS
?a
Chinese_Taiwan_Stroke_CI_AI_KS_WS
?a
Chinese_Taiwan_Stroke_CI_AS
?a
Chinese_Taiwan_Stroke_CI_AS_WS
?a
Chinese_Taiwan_Stroke_CI_AS_KS
?a
Chinese_Taiwan_Stroke_CI_AS_KS_WS
?a
Chinese_Taiwan_Stroke_CS_AI
?a
Chinese_Taiwan_Stroke_CS_AI_WS
?a
Chinese_Taiwan_Stroke_CS_AI_KS
?a
Chinese_Taiwan_Stroke_CS_AI_KS_WS
?a
Chinese_Taiwan_Stroke_CS_AS
?a
Chinese_Taiwan_Stroke_CS_AS_WS
?a
Chinese_Taiwan_Stroke_CS_AS_KS
?a
Chinese_Taiwan_Stroke_CS_AS_KS_WS
?a
Chinese_Taiwan_Stroke_90_BIN
?a
Chinese_Taiwan_Stroke_90_BIN2
?a
Chinese_Taiwan_Stroke_90_CI_AI
?a
Chinese_Taiwan_Stroke_90_CI_AI_WS
?a
Chinese_Taiwan_Stroke_90_CI_AI_KS
?a
Chinese_Taiwan_Stroke_90_CI_AI_KS_WS
?a
Chinese_Taiwan_Stroke_90_CI_AS
?a
Chinese_Taiwan_Stroke_90_CI_AS_WS
?a
Chinese_Taiwan_Stroke_90_CI_AS_KS
?a
Chinese_Taiwan_Stroke_90_CI_AS_KS_WS
?a
Chinese_Taiwan_Stroke_90_CS_AI
?a
Chinese_Taiwan_Stroke_90_CS_AI_WS
?a
Chinese_Taiwan_Stroke_90_CS_AI_KS
?a
Chinese_Taiwan_Stroke_90_CS_AI_KS_WS
?a
Chinese_Taiwan_Stroke_90_CS_AS
?a
Chinese_Taiwan_Stroke_90_CS_AS_WS
?a
Chinese_Taiwan_Stroke_90_CS_AS_KS
?a
Chinese_Taiwan_Stroke_90_CS_AS_KS_WS
?a
Croatian_BIN
¨aY3
Croatian_BIN2
¨aY3
Croatian_CI_AI
¨aY3
Croatian_CI_AI_WS
¨aY3
Croatian_CI_AI_KS
¨aY3
Croatian_CI_AI_KS_WS
¨aY3
Croatian_CI_AS
¨aY3
Croatian_CI_AS_WS
¨aY3
Croatian_CI_AS_KS
¨aY3
Croatian_CI_AS_KS_WS
¨aY3
Croatian_CS_AI
¨aY3
Croatian_CS_AI_WS
¨aY3
Croatian_CS_AI_KS
¨aY3
Croatian_CS_AI_KS_WS
¨aY3
Croatian_CS_AS
¨aY3
Croatian_CS_AS_WS
¨aY3
Croatian_CS_AS_KS
¨aY3
Croatian_CS_AS_KS_WS
¨aY3
Cyrillic_General_BIN
????
Cyrillic_General_BIN2
????
Cyrillic_General_CI_AI
????
Cyrillic_General_CI_AI_WS
????
Cyrillic_General_CI_AI_KS
????
Cyrillic_General_CI_AI_KS_WS
????
Cyrillic_General_CI_AS
????
Cyrillic_General_CI_AS_WS
????
Cyrillic_General_CI_AS_KS
????
Cyrillic_General_CI_AS_KS_WS
????
Cyrillic_General_CS_AI
????
Cyrillic_General_CS_AI_WS
????
Cyrillic_General_CS_AI_KS
????
Cyrillic_General_CS_AI_KS_WS
????
Cyrillic_General_CS_AS
????
Cyrillic_General_CS_AS_WS
????
Cyrillic_General_CS_AS_KS
????
Cyrillic_General_CS_AS_KS_WS
????
Czech_BIN
¨aY3
Czech_BIN2
¨aY3
Czech_CI_AI
¨aY3
Czech_CI_AI_WS
¨aY3
Czech_CI_AI_KS
¨aY3
Czech_CI_AI_KS_WS
¨aY3
Czech_CI_AS
¨aY3
Czech_CI_AS_WS
¨aY3
Czech_CI_AS_KS
¨aY3
Czech_CI_AS_KS_WS
¨aY3
Czech_CS_AI
¨aY3
Czech_CS_AI_WS
¨aY3
Czech_CS_AI_KS
¨aY3
Czech_CS_AI_KS_WS
¨aY3
Czech_CS_AS
¨aY3
Czech_CS_AS_WS
¨aY3
Czech_CS_AS_KS
¨aY3
Czech_CS_AS_KS_WS
¨aY3
Danish_Norwegian_BIN
¨ª¥³
Danish_Norwegian_BIN2
¨ª¥³
Danish_Norwegian_CI_AI
¨ª¥³
Danish_Norwegian_CI_AI_WS
¨ª¥³
Danish_Norwegian_CI_AI_KS
¨ª¥³
Danish_Norwegian_CI_AI_KS_WS
¨ª¥³
Danish_Norwegian_CI_AS
¨ª¥³
Danish_Norwegian_CI_AS_WS
¨ª¥³
Danish_Norwegian_CI_AS_KS
¨ª¥³
Danish_Norwegian_CI_AS_KS_WS
¨ª¥³
Danish_Norwegian_CS_AI
¨ª¥³
Danish_Norwegian_CS_AI_WS
¨ª¥³
Danish_Norwegian_CS_AI_KS
¨ª¥³
Danish_Norwegian_CS_AI_KS_WS
¨ª¥³
Danish_Norwegian_CS_AS
¨ª¥³
Danish_Norwegian_CS_AS_WS
¨ª¥³
Danish_Norwegian_CS_AS_KS
¨ª¥³
Danish_Norwegian_CS_AS_KS_WS
¨ª¥³
Divehi_90_BIN
Msg 459, Level 16, State 1, Line 1
Collation 'Divehi_90_BIN' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Divehi_90_BIN2
Msg 459, Level 16, State 1, Line 1
Collation 'Divehi_90_BIN2' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Divehi_90_CI_AI
Msg 459, Level 16, State 1, Line 1
Collation 'Divehi_90_CI_AI' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Divehi_90_CI_AI_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Divehi_90_CI_AI_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Divehi_90_CI_AI_KS
Msg 459, Level 16, State 1, Line 1
Collation 'Divehi_90_CI_AI_KS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Divehi_90_CI_AI_KS_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Divehi_90_CI_AI_KS_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Divehi_90_CI_AS
Msg 459, Level 16, State 1, Line 1
Collation 'Divehi_90_CI_AS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Divehi_90_CI_AS_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Divehi_90_CI_AS_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Divehi_90_CI_AS_KS
Msg 459, Level 16, State 1, Line 1
Collation 'Divehi_90_CI_AS_KS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Divehi_90_CI_AS_KS_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Divehi_90_CI_AS_KS_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Divehi_90_CS_AI
Msg 459, Level 16, State 1, Line 1
Collation 'Divehi_90_CS_AI' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Divehi_90_CS_AI_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Divehi_90_CS_AI_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Divehi_90_CS_AI_KS
Msg 459, Level 16, State 1, Line 1
Collation 'Divehi_90_CS_AI_KS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Divehi_90_CS_AI_KS_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Divehi_90_CS_AI_KS_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Divehi_90_CS_AS
Msg 459, Level 16, State 1, Line 1
Collation 'Divehi_90_CS_AS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Divehi_90_CS_AS_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Divehi_90_CS_AS_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Divehi_90_CS_AS_KS
Msg 459, Level 16, State 1, Line 1
Collation 'Divehi_90_CS_AS_KS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Divehi_90_CS_AS_KS_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Divehi_90_CS_AS_KS_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Estonian_BIN
¨??³
Estonian_BIN2
¨??³
Estonian_CI_AI
¨??³
Estonian_CI_AI_WS
¨??³
Estonian_CI_AI_KS
¨??³
Estonian_CI_AI_KS_WS
¨??³
Estonian_CI_AS
¨??³
Estonian_CI_AS_WS
¨??³
Estonian_CI_AS_KS
¨??³
Estonian_CI_AS_KS_WS
¨??³
Estonian_CS_AI
¨??³
Estonian_CS_AI_WS
¨??³
Estonian_CS_AI_KS
¨??³
Estonian_CS_AI_KS_WS
¨??³
Estonian_CS_AS
¨??³
Estonian_CS_AS_WS
¨??³
Estonian_CS_AS_KS
¨??³
Estonian_CS_AS_KS_WS
¨??³
Finnish_Swedish_BIN
¨ª¥³
Finnish_Swedish_BIN2
¨ª¥³
Finnish_Swedish_CI_AI
¨ª¥³
Finnish_Swedish_CI_AI_WS
¨ª¥³
Finnish_Swedish_CI_AI_KS
¨ª¥³
Finnish_Swedish_CI_AI_KS_WS
¨ª¥³
Finnish_Swedish_CI_AS
¨ª¥³
Finnish_Swedish_CI_AS_WS
¨ª¥³
Finnish_Swedish_CI_AS_KS
¨ª¥³
Finnish_Swedish_CI_AS_KS_WS
¨ª¥³
Finnish_Swedish_CS_AI
¨ª¥³
Finnish_Swedish_CS_AI_WS
¨ª¥³
Finnish_Swedish_CS_AI_KS
¨ª¥³
Finnish_Swedish_CS_AI_KS_WS
¨ª¥³
Finnish_Swedish_CS_AS
¨ª¥³
Finnish_Swedish_CS_AS_WS
¨ª¥³
Finnish_Swedish_CS_AS_KS
¨ª¥³
Finnish_Swedish_CS_AS_KS_WS
¨ª¥³
French_BIN
¨ª¥³
French_BIN2
¨ª¥³
French_CI_AI
¨ª¥³
French_CI_AI_WS
¨ª¥³
French_CI_AI_KS
¨ª¥³
French_CI_AI_KS_WS
¨ª¥³
French_CI_AS
¨ª¥³
French_CI_AS_WS
¨ª¥³
French_CI_AS_KS
¨ª¥³
French_CI_AS_KS_WS
¨ª¥³
French_CS_AI
¨ª¥³
French_CS_AI_WS
¨ª¥³
French_CS_AI_KS
¨ª¥³
French_CS_AI_KS_WS
¨ª¥³
French_CS_AS
¨ª¥³
French_CS_AS_WS
¨ª¥³
French_CS_AS_KS
¨ª¥³
French_CS_AS_KS_WS
¨ª¥³
Georgian_Modern_Sort_BIN
¨ª¥³
Georgian_Modern_Sort_BIN2
¨ª¥³
Georgian_Modern_Sort_CI_AI
¨ª¥³
Georgian_Modern_Sort_CI_AI_WS
¨ª¥³
Georgian_Modern_Sort_CI_AI_KS
¨ª¥³
Georgian_Modern_Sort_CI_AI_KS_WS
¨ª¥³
Georgian_Modern_Sort_CI_AS
¨ª¥³
Georgian_Modern_Sort_CI_AS_WS
¨ª¥³
Georgian_Modern_Sort_CI_AS_KS
¨ª¥³
Georgian_Modern_Sort_CI_AS_KS_WS
¨ª¥³
Georgian_Modern_Sort_CS_AI
¨ª¥³
Georgian_Modern_Sort_CS_AI_WS
¨ª¥³
Georgian_Modern_Sort_CS_AI_KS
¨ª¥³
Georgian_Modern_Sort_CS_AI_KS_WS
¨ª¥³
Georgian_Modern_Sort_CS_AS
¨ª¥³
Georgian_Modern_Sort_CS_AS_WS
¨ª¥³
Georgian_Modern_Sort_CS_AS_KS
¨ª¥³
Georgian_Modern_Sort_CS_AS_KS_WS
¨ª¥³
German_PhoneBook_BIN
¨ª¥³
German_PhoneBook_BIN2
¨ª¥³
German_PhoneBook_CI_AI
¨ª¥³
German_PhoneBook_CI_AI_WS
¨ª¥³
German_PhoneBook_CI_AI_KS
¨ª¥³
German_PhoneBook_CI_AI_KS_WS
¨ª¥³
German_PhoneBook_CI_AS
¨ª¥³
German_PhoneBook_CI_AS_WS
¨ª¥³
German_PhoneBook_CI_AS_KS
¨ª¥³
German_PhoneBook_CI_AS_KS_WS
¨ª¥³
German_PhoneBook_CS_AI
¨ª¥³
German_PhoneBook_CS_AI_WS
¨ª¥³
German_PhoneBook_CS_AI_KS
¨ª¥³
German_PhoneBook_CS_AI_KS_WS
¨ª¥³
German_PhoneBook_CS_AS
¨ª¥³
German_PhoneBook_CS_AS_WS
¨ª¥³
German_PhoneBook_CS_AS_KS
¨ª¥³
German_PhoneBook_CS_AS_KS_WS
¨ª¥³
Greek_BIN
¨?¥³
Greek_BIN2
¨?¥³
Greek_CI_AI
¨?¥³
Greek_CI_AI_WS
¨?¥³
Greek_CI_AI_KS
¨?¥³
Greek_CI_AI_KS_WS
¨?¥³
Greek_CI_AS
¨?¥³
Greek_CI_AS_WS
¨?¥³
Greek_CI_AS_KS
¨?¥³
Greek_CI_AS_KS_WS
¨?¥³
Greek_CS_AI
¨?¥³
Greek_CS_AI_WS
¨?¥³
Greek_CS_AI_KS
¨?¥³
Greek_CS_AI_KS_WS
¨?¥³
Greek_CS_AS
¨?¥³
Greek_CS_AS_WS
¨?¥³
Greek_CS_AS_KS
¨?¥³
Greek_CS_AS_KS_WS
¨?¥³
Hebrew_BIN
¨?¥³
Hebrew_BIN2
¨?¥³
Hebrew_CI_AI
¨?¥³
Hebrew_CI_AI_WS
¨?¥³
Hebrew_CI_AI_KS
¨?¥³
Hebrew_CI_AI_KS_WS
¨?¥³
Hebrew_CI_AS
¨?¥³
Hebrew_CI_AS_WS
¨?¥³
Hebrew_CI_AS_KS
¨?¥³
Hebrew_CI_AS_KS_WS
¨?¥³
Hebrew_CS_AI
¨?¥³
Hebrew_CS_AI_WS
¨?¥³
Hebrew_CS_AI_KS
¨?¥³
Hebrew_CS_AI_KS_WS
¨?¥³
Hebrew_CS_AS
¨?¥³
Hebrew_CS_AS_WS
¨?¥³
Hebrew_CS_AS_KS
¨?¥³
Hebrew_CS_AS_KS_WS
¨?¥³
Hungarian_BIN
¨aY3
Hungarian_BIN2
¨aY3
Hungarian_CI_AI
¨aY3
Hungarian_CI_AI_WS
¨aY3
Hungarian_CI_AI_KS
¨aY3
Hungarian_CI_AI_KS_WS
¨aY3
Hungarian_CI_AS
¨aY3
Hungarian_CI_AS_WS
¨aY3
Hungarian_CI_AS_KS
¨aY3
Hungarian_CI_AS_KS_WS
¨aY3
Hungarian_CS_AI
¨aY3
Hungarian_CS_AI_WS
¨aY3
Hungarian_CS_AI_KS
¨aY3
Hungarian_CS_AI_KS_WS
¨aY3
Hungarian_CS_AS
¨aY3
Hungarian_CS_AS_WS
¨aY3
Hungarian_CS_AS_KS
¨aY3
Hungarian_CS_AS_KS_WS
¨aY3
Hungarian_Technical_BIN
¨aY3
Hungarian_Technical_BIN2
¨aY3
Hungarian_Technical_CI_AI
¨aY3
Hungarian_Technical_CI_AI_WS
¨aY3
Hungarian_Technical_CI_AI_KS
¨aY3
Hungarian_Technical_CI_AI_KS_WS
¨aY3
Hungarian_Technical_CI_AS
¨aY3
Hungarian_Technical_CI_AS_WS
¨aY3
Hungarian_Technical_CI_AS_KS
¨aY3
Hungarian_Technical_CI_AS_KS_WS
¨aY3
Hungarian_Technical_CS_AI
¨aY3
Hungarian_Technical_CS_AI_WS
¨aY3
Hungarian_Technical_CS_AI_KS
¨aY3
Hungarian_Technical_CS_AI_KS_WS
¨aY3
Hungarian_Technical_CS_AS
¨aY3
Hungarian_Technical_CS_AS_WS
¨aY3
Hungarian_Technical_CS_AS_KS
¨aY3
Hungarian_Technical_CS_AS_KS_WS
¨aY3
Icelandic_BIN
¨ª¥³
Icelandic_BIN2
¨ª¥³
Icelandic_CI_AI
¨ª¥³
Icelandic_CI_AI_WS
¨ª¥³
Icelandic_CI_AI_KS
¨ª¥³
Icelandic_CI_AI_KS_WS
¨ª¥³
Icelandic_CI_AS
¨ª¥³
Icelandic_CI_AS_WS
¨ª¥³
Icelandic_CI_AS_KS
¨ª¥³
Icelandic_CI_AS_KS_WS
¨ª¥³
Icelandic_CS_AI
¨ª¥³
Icelandic_CS_AI_WS
¨ª¥³
Icelandic_CS_AI_KS
¨ª¥³
Icelandic_CS_AI_KS_WS
¨ª¥³
Icelandic_CS_AS
¨ª¥³
Icelandic_CS_AS_WS
¨ª¥³
Icelandic_CS_AS_KS
¨ª¥³
Icelandic_CS_AS_KS_WS
¨ª¥³
Indic_General_90_BIN
Msg 459, Level 16, State 1, Line 1
Collation 'Indic_General_90_BIN' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Indic_General_90_BIN2
Msg 459, Level 16, State 1, Line 1
Collation 'Indic_General_90_BIN2' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Indic_General_90_CI_AI
Msg 459, Level 16, State 1, Line 1
Collation 'Indic_General_90_CI_AI' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Indic_General_90_CI_AI_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Indic_General_90_CI_AI_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Indic_General_90_CI_AI_KS
Msg 459, Level 16, State 1, Line 1
Collation 'Indic_General_90_CI_AI_KS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Indic_General_90_CI_AI_KS_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Indic_General_90_CI_AI_KS_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Indic_General_90_CI_AS
Msg 459, Level 16, State 1, Line 1
Collation 'Indic_General_90_CI_AS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Indic_General_90_CI_AS_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Indic_General_90_CI_AS_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Indic_General_90_CI_AS_KS
Msg 459, Level 16, State 1, Line 1
Collation 'Indic_General_90_CI_AS_KS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Indic_General_90_CI_AS_KS_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Indic_General_90_CI_AS_KS_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Indic_General_90_CS_AI
Msg 459, Level 16, State 1, Line 1
Collation 'Indic_General_90_CS_AI' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Indic_General_90_CS_AI_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Indic_General_90_CS_AI_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Indic_General_90_CS_AI_KS
Msg 459, Level 16, State 1, Line 1
Collation 'Indic_General_90_CS_AI_KS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Indic_General_90_CS_AI_KS_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Indic_General_90_CS_AI_KS_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Indic_General_90_CS_AS
Msg 459, Level 16, State 1, Line 1
Collation 'Indic_General_90_CS_AS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Indic_General_90_CS_AS_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Indic_General_90_CS_AS_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Indic_General_90_CS_AS_KS
Msg 459, Level 16, State 1, Line 1
Collation 'Indic_General_90_CS_AS_KS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Indic_General_90_CS_AS_KS_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Indic_General_90_CS_AS_KS_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Japanese_BIN
¨aJapanese_BIN2
¨aJapanese_CI_AI
¨aJapanese_CI_AI_WS
¨aJapanese_CI_AI_KS
¨aJapanese_CI_AI_KS_WS
¨aJapanese_CI_AS
¨aJapanese_CI_AS_WS
¨aJapanese_CI_AS_KS
¨aJapanese_CI_AS_KS_WS
¨aJapanese_CS_AI
¨aJapanese_CS_AI_WS
¨aJapanese_CS_AI_KS
¨aJapanese_CS_AI_KS_WS
¨aJapanese_CS_AS
¨aJapanese_CS_AS_WS
¨aJapanese_CS_AS_KS
¨aJapanese_CS_AS_KS_WS
¨aJapanese_90_BIN
¨aJapanese_90_BIN2
¨aJapanese_90_CI_AI
¨aJapanese_90_CI_AI_WS
¨aJapanese_90_CI_AI_KS
¨aJapanese_90_CI_AI_KS_WS
¨aJapanese_90_CI_AS
¨aJapanese_90_CI_AS_WS
¨aJapanese_90_CI_AS_KS
¨aJapanese_90_CI_AS_KS_WS
¨aJapanese_90_CS_AI
¨aJapanese_90_CS_AI_WS
¨aJapanese_90_CS_AI_KS
¨aJapanese_90_CS_AI_KS_WS
¨aJapanese_90_CS_AS
¨aJapanese_90_CS_AS_WS
¨aJapanese_90_CS_AS_KS
¨aJapanese_90_CS_AS_KS_WS
¨aJapanese_Unicode_BIN
¨aJapanese_Unicode_BIN2
¨aJapanese_Unicode_CI_AI
¨aJapanese_Unicode_CI_AI_WS
¨aJapanese_Unicode_CI_AI_KS
¨aJapanese_Unicode_CI_AI_KS_WS
¨aJapanese_Unicode_CI_AS
¨aJapanese_Unicode_CI_AS_WS
¨aJapanese_Unicode_CI_AS_KS
¨aJapanese_Unicode_CI_AS_KS_WS
¨aJapanese_Unicode_CS_AI
¨aJapanese_Unicode_CS_AI_WS
¨aJapanese_Unicode_CS_AI_KS
¨aJapanese_Unicode_CS_AI_KS_WS
¨aJapanese_Unicode_CS_AS
¨aJapanese_Unicode_CS_AS_WS
¨aJapanese_Unicode_CS_AS_KS
¨aJapanese_Unicode_CS_AS_KS_WS
¨aKazakh_90_BIN
????
Kazakh_90_BIN2
????
Kazakh_90_CI_AI
????
Kazakh_90_CI_AI_WS
????
Kazakh_90_CI_AI_KS
????
Kazakh_90_CI_AI_KS_WS
????
Kazakh_90_CI_AS
????
Kazakh_90_CI_AS_WS
????
Kazakh_90_CI_AS_KS
????
Kazakh_90_CI_AS_KS_WS
????
Kazakh_90_CS_AI
????
Kazakh_90_CS_AI_WS
????
Kazakh_90_CS_AI_KS
????
Kazakh_90_CS_AI_KS_WS
????
Kazakh_90_CS_AS
????
Kazakh_90_CS_AS_WS
????
Kazakh_90_CS_AS_KS
????
Kazakh_90_CS_AS_KS_WS
????
Korean_90_BIN
¨ª
Korean_90_BIN2
¨ª
Korean_90_CI_AI
¨ª
Korean_90_CI_AI_WS
¨ª
Korean_90_CI_AI_KS
¨ª
Korean_90_CI_AI_KS_WS
¨ª
Korean_90_CI_AS
¨ª
Korean_90_CI_AS_WS
¨ª
Korean_90_CI_AS_KS
¨ª
Korean_90_CI_AS_KS_WS
¨ª
Korean_90_CS_AI
¨ª
Korean_90_CS_AI_WS
¨ª
Korean_90_CS_AI_KS
¨ª
Korean_90_CS_AI_KS_WS
¨ª
Korean_90_CS_AS
¨ª
Korean_90_CS_AS_WS
¨ª
Korean_90_CS_AS_KS
¨ª
Korean_90_CS_AS_KS_WS
¨ª
Korean_Wansung_BIN
¨ª
Korean_Wansung_BIN2
¨ª
Korean_Wansung_CI_AI
¨ª
Korean_Wansung_CI_AI_WS
¨ª
Korean_Wansung_CI_AI_KS
¨ª
Korean_Wansung_CI_AI_KS_WS
¨ª
Korean_Wansung_CI_AS
¨ª
Korean_Wansung_CI_AS_WS
¨ª
Korean_Wansung_CI_AS_KS
¨ª
Korean_Wansung_CI_AS_KS_WS
¨ª
Korean_Wansung_CS_AI
¨ª
Korean_Wansung_CS_AI_WS
¨ª
Korean_Wansung_CS_AI_KS
¨ª
Korean_Wansung_CS_AI_KS_WS
¨ª
Korean_Wansung_CS_AS
¨ª
Korean_Wansung_CS_AS_WS
¨ª
Korean_Wansung_CS_AS_KS
¨ª
Korean_Wansung_CS_AS_KS_WS
¨ª
Latin1_General_BIN
¨ª¥³
Latin1_General_BIN2
¨ª¥³
Latin1_General_CI_AI
¨ª¥³
Latin1_General_CI_AI_WS
¨ª¥³
Latin1_General_CI_AI_KS
¨ª¥³
Latin1_General_CI_AI_KS_WS
¨ª¥³
Latin1_General_CI_AS
¨ª¥³
Latin1_General_CI_AS_WS
¨ª¥³
Latin1_General_CI_AS_KS
¨ª¥³
Latin1_General_CI_AS_KS_WS
¨ª¥³
Latin1_General_CS_AI
¨ª¥³
Latin1_General_CS_AI_WS
¨ª¥³
Latin1_General_CS_AI_KS
¨ª¥³
Latin1_General_CS_AI_KS_WS
¨ª¥³
Latin1_General_CS_AS
¨ª¥³
Latin1_General_CS_AS_WS
¨ª¥³
Latin1_General_CS_AS_KS
¨ª¥³
Latin1_General_CS_AS_KS_WS
¨ª¥³
Latvian_BIN
¨??³
Latvian_BIN2
¨??³
Latvian_CI_AI
¨??³
Latvian_CI_AI_WS
¨??³
Latvian_CI_AI_KS
¨??³
Latvian_CI_AI_KS_WS
¨??³
Latvian_CI_AS
¨??³
Latvian_CI_AS_WS
¨??³
Latvian_CI_AS_KS
¨??³
Latvian_CI_AS_KS_WS
¨??³
Latvian_CS_AI
¨??³
Latvian_CS_AI_WS
¨??³
Latvian_CS_AI_KS
¨??³
Latvian_CS_AI_KS_WS
¨??³
Latvian_CS_AS
¨??³
Latvian_CS_AS_WS
¨??³
Latvian_CS_AS_KS
¨??³
Latvian_CS_AS_KS_WS
¨??³
Lithuanian_BIN
¨??³
Lithuanian_BIN2
¨??³
Lithuanian_CI_AI
¨??³
Lithuanian_CI_AI_WS
¨??³
Lithuanian_CI_AI_KS
¨??³
Lithuanian_CI_AI_KS_WS
¨??³
Lithuanian_CI_AS
¨??³
Lithuanian_CI_AS_WS
¨??³
Lithuanian_CI_AS_KS
¨??³
Lithuanian_CI_AS_KS_WS
¨??³
Lithuanian_CS_AI
¨??³
Lithuanian_CS_AI_WS
¨??³
Lithuanian_CS_AI_KS
¨??³
Lithuanian_CS_AI_KS_WS
¨??³
Lithuanian_CS_AS
¨??³
Lithuanian_CS_AS_WS
¨??³
Lithuanian_CS_AS_KS
¨??³
Lithuanian_CS_AS_KS_WS
¨??³
Macedonian_FYROM_90_BIN
????
Macedonian_FYROM_90_BIN2
????
Macedonian_FYROM_90_CI_AI
????
Macedonian_FYROM_90_CI_AI_WS
????
Macedonian_FYROM_90_CI_AI_KS
????
Macedonian_FYROM_90_CI_AI_KS_WS
????
Macedonian_FYROM_90_CI_AS
????
Macedonian_FYROM_90_CI_AS_WS
????
Macedonian_FYROM_90_CI_AS_KS
????
Macedonian_FYROM_90_CI_AS_KS_WS
????
Macedonian_FYROM_90_CS_AI
????
Macedonian_FYROM_90_CS_AI_WS
????
Macedonian_FYROM_90_CS_AI_KS
????
Macedonian_FYROM_90_CS_AI_KS_WS
????
Macedonian_FYROM_90_CS_AS
????
Macedonian_FYROM_90_CS_AS_WS
????
Macedonian_FYROM_90_CS_AS_KS
????
Macedonian_FYROM_90_CS_AS_KS_WS
????
Modern_Spanish_BIN
¨ª¥³
Modern_Spanish_BIN2
¨ª¥³
Modern_Spanish_CI_AI
¨ª¥³
Modern_Spanish_CI_AI_WS
¨ª¥³
Modern_Spanish_CI_AI_KS
¨ª¥³
Modern_Spanish_CI_AI_KS_WS
¨ª¥³
Modern_Spanish_CI_AS
¨ª¥³
Modern_Spanish_CI_AS_WS
¨ª¥³
Modern_Spanish_CI_AS_KS
¨ª¥³
Modern_Spanish_CI_AS_KS_WS
¨ª¥³
Modern_Spanish_CS_AI
¨ª¥³
Modern_Spanish_CS_AI_WS
¨ª¥³
Modern_Spanish_CS_AI_KS
¨ª¥³
Modern_Spanish_CS_AI_KS_WS
¨ª¥³
Modern_Spanish_CS_AS
¨ª¥³
Modern_Spanish_CS_AS_WS
¨ª¥³
Modern_Spanish_CS_AS_KS
¨ª¥³
Modern_Spanish_CS_AS_KS_WS
¨ª¥³
Polish_BIN
¨aY3
Polish_BIN2
¨aY3
Polish_CI_AI
¨aY3
Polish_CI_AI_WS
¨aY3
Polish_CI_AI_KS
¨aY3
Polish_CI_AI_KS_WS
¨aY3
Polish_CI_AS
¨aY3
Polish_CI_AS_WS
¨aY3
Polish_CI_AS_KS
¨aY3
Polish_CI_AS_KS_WS
¨aY3
Polish_CS_AI
¨aY3
Polish_CS_AI_WS
¨aY3
Polish_CS_AI_KS
¨aY3
Polish_CS_AI_KS_WS
¨aY3
Polish_CS_AS
¨aY3
Polish_CS_AS_WS
¨aY3
Polish_CS_AS_KS
¨aY3
Polish_CS_AS_KS_WS
¨aY3
Romanian_BIN
¨aY3
Romanian_BIN2
¨aY3
Romanian_CI_AI
¨aY3
Romanian_CI_AI_WS
¨aY3
Romanian_CI_AI_KS
¨aY3
Romanian_CI_AI_KS_WS
¨aY3
Romanian_CI_AS
¨aY3
Romanian_CI_AS_WS
¨aY3
Romanian_CI_AS_KS
¨aY3
Romanian_CI_AS_KS_WS
¨aY3
Romanian_CS_AI
¨aY3
Romanian_CS_AI_WS
¨aY3
Romanian_CS_AI_KS
¨aY3
Romanian_CS_AI_KS_WS
¨aY3
Romanian_CS_AS
¨aY3
Romanian_CS_AS_WS
¨aY3
Romanian_CS_AS_KS
¨aY3
Romanian_CS_AS_KS_WS
¨aY3
Slovak_BIN
¨aY3
Slovak_BIN2
¨aY3
Slovak_CI_AI
¨aY3
Slovak_CI_AI_WS
¨aY3
Slovak_CI_AI_KS
¨aY3
Slovak_CI_AI_KS_WS
¨aY3
Slovak_CI_AS
¨aY3
Slovak_CI_AS_WS
¨aY3
Slovak_CI_AS_KS
¨aY3
Slovak_CI_AS_KS_WS
¨aY3
Slovak_CS_AI
¨aY3
Slovak_CS_AI_WS
¨aY3
Slovak_CS_AI_KS
¨aY3
Slovak_CS_AI_KS_WS
¨aY3
Slovak_CS_AS
¨aY3
Slovak_CS_AS_WS
¨aY3
Slovak_CS_AS_KS
¨aY3
Slovak_CS_AS_KS_WS
¨aY3
Slovenian_BIN
¨aY3
Slovenian_BIN2
¨aY3
Slovenian_CI_AI
¨aY3
Slovenian_CI_AI_WS
¨aY3
Slovenian_CI_AI_KS
¨aY3
Slovenian_CI_AI_KS_WS
¨aY3
Slovenian_CI_AS
¨aY3
Slovenian_CI_AS_WS
¨aY3
Slovenian_CI_AS_KS
¨aY3
Slovenian_CI_AS_KS_WS
¨aY3
Slovenian_CS_AI
¨aY3
Slovenian_CS_AI_WS
¨aY3
Slovenian_CS_AI_KS
¨aY3
Slovenian_CS_AI_KS_WS
¨aY3
Slovenian_CS_AS
¨aY3
Slovenian_CS_AS_WS
¨aY3
Slovenian_CS_AS_KS
¨aY3
Slovenian_CS_AS_KS_WS
¨aY3
Syriac_90_BIN
Msg 459, Level 16, State 1, Line 1
Collation 'Syriac_90_BIN' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Syriac_90_BIN2
Msg 459, Level 16, State 1, Line 1
Collation 'Syriac_90_BIN2' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Syriac_90_CI_AI
Msg 459, Level 16, State 1, Line 1
Collation 'Syriac_90_CI_AI' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Syriac_90_CI_AI_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Syriac_90_CI_AI_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Syriac_90_CI_AI_KS
Msg 459, Level 16, State 1, Line 1
Collation 'Syriac_90_CI_AI_KS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Syriac_90_CI_AI_KS_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Syriac_90_CI_AI_KS_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Syriac_90_CI_AS
Msg 459, Level 16, State 1, Line 1
Collation 'Syriac_90_CI_AS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Syriac_90_CI_AS_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Syriac_90_CI_AS_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Syriac_90_CI_AS_KS
Msg 459, Level 16, State 1, Line 1
Collation 'Syriac_90_CI_AS_KS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Syriac_90_CI_AS_KS_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Syriac_90_CI_AS_KS_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Syriac_90_CS_AI
Msg 459, Level 16, State 1, Line 1
Collation 'Syriac_90_CS_AI' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Syriac_90_CS_AI_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Syriac_90_CS_AI_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Syriac_90_CS_AI_KS
Msg 459, Level 16, State 1, Line 1
Collation 'Syriac_90_CS_AI_KS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Syriac_90_CS_AI_KS_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Syriac_90_CS_AI_KS_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Syriac_90_CS_AS
Msg 459, Level 16, State 1, Line 1
Collation 'Syriac_90_CS_AS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Syriac_90_CS_AS_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Syriac_90_CS_AS_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Syriac_90_CS_AS_KS
Msg 459, Level 16, State 1, Line 1
Collation 'Syriac_90_CS_AS_KS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Syriac_90_CS_AS_KS_WS
Msg 459, Level 16, State 1, Line 1
Collation 'Syriac_90_CS_AS_KS_WS' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.
Tatar_90_BIN
????
Tatar_90_BIN2
????
Tatar_90_CI_AI
????
Tatar_90_CI_AI_WS
????
Tatar_90_CI_AI_KS
????
Tatar_90_CI_AI_KS_WS
????
Tatar_90_CI_AS
????
Tatar_90_CI_AS_WS
????
Tatar_90_CI_AS_KS
????
Tatar_90_CI_AS_KS_WS
????
Tatar_90_CS_AI
????
Tatar_90_CS_AI_WS
????
Tatar_90_CS_AI_KS
????
Tatar_90_CS_AI_KS_WS
????
Tatar_90_CS_AS
????
Tatar_90_CS_AS_WS
????
Tatar_90_CS_AS_KS
????
Tatar_90_CS_AS_KS_WS
????
Thai_BIN
????
Thai_BIN2
????
Thai_CI_AI
????
Thai_CI_AI_WS
????
Thai_CI_AI_KS
????
Thai_CI_AI_KS_WS
????
Thai_CI_AS
????
Thai_CI_AS_WS
????
Thai_CI_AS_KS
????
Thai_CI_AS_KS_WS
????
Thai_CS_AI
????
Thai_CS_AI_WS
????
Thai_CS_AI_KS
????
Thai_CS_AI_KS_WS
????
Thai_CS_AS
????
Thai_CS_AS_WS
????
Thai_CS_AS_KS
????
Thai_CS_AS_KS_WS
????
Traditional_Spanish_BIN
¨ª¥³
Traditional_Spanish_BIN2
¨ª¥³
Traditional_Spanish_CI_AI
¨ª¥³
Traditional_Spanish_CI_AI_WS
¨ª¥³
Traditional_Spanish_CI_AI_KS
¨ª¥³
Traditional_Spanish_CI_AI_KS_WS
¨ª¥³
Traditional_Spanish_CI_AS
¨ª¥³
Traditional_Spanish_CI_AS_WS
¨ª¥³
Traditional_Spanish_CI_AS_KS
¨ª¥³
Traditional_Spanish_CI_AS_KS_WS
¨ª¥³
Traditional_Spanish_CS_AI
¨ª¥³
Traditional_Spanish_CS_AI_WS
¨ª¥³
Traditional_Spanish_CS_AI_KS
¨ª¥³
Traditional_Spanish_CS_AI_KS_WS
¨ª¥³
Traditional_Spanish_CS_AS
¨ª¥³
Traditional_Spanish_CS_AS_WS
¨ª¥³
Traditional_Spanish_CS_AS_KS
¨ª¥³
Traditional_Spanish_CS_AS_KS_WS
¨ª¥³
Turkish_BIN
¨ª¥³
Turkish_BIN2
¨ª¥³
Turkish_CI_AI
¨ª¥³
Turkish_CI_AI_WS
¨ª¥³
Turkish_CI_AI_KS
¨ª¥³
Turkish_CI_AI_KS_WS
¨ª¥³
Turkish_CI_AS
¨ª¥³
Turkish_CI_AS_WS
¨ª¥³
Turkish_CI_AS_KS
¨ª¥³
Turkish_CI_AS_KS_WS
¨ª¥³
Turkish_CS_AI
¨ª¥³
Turkish_CS_AI_WS
¨ª¥³
Turkish_CS_AI_KS
¨ª¥³
Turkish_CS_AI_KS_WS
¨ª¥³
Turkish_CS_AS
¨ª¥³
Turkish_CS_AS_WS
¨ª¥³
Turkish_CS_AS_KS
¨ª¥³
Turkish_CS_AS_KS_WS
¨ª¥³
Ukrainian_BIN
????
Ukrainian_BIN2
????
Ukrainian_CI_AI
????
Ukrainian_CI_AI_WS
????
Ukrainian_CI_AI_KS
????
Ukrainian_CI_AI_KS_WS
????
Ukrainian_CI_AS
????
Ukrainian_CI_AS_WS
????
Ukrainian_CI_AS_KS
????
Ukrainian_CI_AS_KS_WS
????
Ukrainian_CS_AI
????
Ukrainian_CS_AI_WS
????
Ukrainian_CS_AI_KS
????
Ukrainian_CS_AI_KS_WS
????
Ukrainian_CS_AS
????
Ukrainian_CS_AS_WS
????
Ukrainian_CS_AS_KS
????
Ukrainian_CS_AS_KS_WS
????
Uzbek_Latin_90_BIN
¨ª¥³
Uzbek_Latin_90_BIN2
¨ª¥³
Uzbek_Latin_90_CI_AI
¨ª¥³
Uzbek_Latin_90_CI_AI_WS
¨ª¥³
Uzbek_Latin_90_CI_AI_KS
¨ª¥³
Uzbek_Latin_90_CI_AI_KS_WS
¨ª¥³
Uzbek_Latin_90_CI_AS
¨ª¥³
Uzbek_Latin_90_CI_AS_WS
¨ª¥³
Uzbek_Latin_90_CI_AS_KS
¨ª¥³
Uzbek_Latin_90_CI_AS_KS_WS
¨ª¥³
Uzbek_Latin_90_CS_AI
¨ª¥³
Uzbek_Latin_90_CS_AI_WS
¨ª¥³
Uzbek_Latin_90_CS_AI_KS
¨ª¥³
Uzbek_Latin_90_CS_AI_KS_WS
¨ª¥³
Uzbek_Latin_90_CS_AS
¨ª¥³
Uzbek_Latin_90_CS_AS_WS
¨ª¥³
Uzbek_Latin_90_CS_AS_KS
¨ª¥³
Uzbek_Latin_90_CS_AS_KS_WS
¨ª¥³
Vietnamese_BIN
¨ª¥³
Vietnamese_BIN2
¨ª¥³
Vietnamese_CI_AI
¨ª¥³
Vietnamese_CI_AI_WS
¨ª¥³
Vietnamese_CI_AI_KS
¨ª¥³
Vietnamese_CI_AI_KS_WS
¨ª¥³
Vietnamese_CI_AS
¨ª¥³
Vietnamese_CI_AS_WS
¨ª¥³
Vietnamese_CI_AS_KS
¨ª¥³
Vietnamese_CI_AS_KS_WS
¨ª¥³
Vietnamese_CS_AI
¨ª¥³
Vietnamese_CS_AI_WS
¨ª¥³
Vietnamese_CS_AI_KS
¨ª¥³
Vietnamese_CS_AI_KS_WS
¨ª¥³
Vietnamese_CS_AS
¨ª¥³
Vietnamese_CS_AS_WS
¨ª¥³
Vietnamese_CS_AS_KS
¨ª¥³
Vietnamese_CS_AS_KS_WS
¨ª¥³
SQL_1xCompat_CP850_CI_AS
¨ª¥³
SQL_AltDiction_CP850_CI_AI
¨ª¥³
SQL_AltDiction_CP850_CI_AS
¨ª¥³
SQL_AltDiction_CP850_CS_AS
¨ª¥³
SQL_AltDiction_Pref_CP850_CI_AS
¨ª¥³
SQL_AltDiction2_CP1253_CS_AS
¨?¥³
SQL_Croatian_CP1250_CI_AS
¨aY3
SQL_Croatian_CP1250_CS_AS
¨aY3
SQL_Czech_CP1250_CI_AS
¨aY3
SQL_Czech_CP1250_CS_AS
¨aY3
SQL_Danish_Pref_CP1_CI_AS
¨ª¥³
SQL_EBCDIC037_CP1_CS_AS
¨ª¥³
SQL_EBCDIC273_CP1_CS_AS
¨ª¥³
SQL_EBCDIC277_CP1_CS_AS
¨ª¥³
SQL_EBCDIC278_CP1_CS_AS
¨ª¥³
SQL_EBCDIC280_CP1_CS_AS
¨ª¥³
SQL_EBCDIC284_CP1_CS_AS
¨ª¥³
SQL_EBCDIC285_CP1_CS_AS
¨ª¥³
SQL_EBCDIC297_CP1_CS_AS
¨ª¥³
SQL_Estonian_CP1257_CI_AS
¨??³
SQL_Estonian_CP1257_CS_AS
¨??³
SQL_Hungarian_CP1250_CI_AS
¨aY3
SQL_Hungarian_CP1250_CS_AS
¨aY3
SQL_Icelandic_Pref_CP1_CI_AS
¨ª¥³
SQL_Latin1_General_CP1_CI_AI
¨ª¥³
SQL_Latin1_General_CP1_CI_AS
¨ª¥³
SQL_Latin1_General_CP1_CS_AS
¨ª¥³
SQL_Latin1_General_CP1250_CI_AS
¨aY3
SQL_Latin1_General_CP1250_CS_AS
¨aY3
SQL_Latin1_General_CP1251_CI_AS
????
SQL_Latin1_General_CP1251_CS_AS
????
SQL_Latin1_General_CP1253_CI_AI
¨?¥³
SQL_Latin1_General_CP1253_CI_AS
¨?¥³
SQL_Latin1_General_CP1253_CS_AS
¨?¥³
SQL_Latin1_General_CP1254_CI_AS
¨ª¥³
SQL_Latin1_General_CP1254_CS_AS
¨ª¥³
SQL_Latin1_General_CP1255_CI_AS
¨?¥³
SQL_Latin1_General_CP1255_CS_AS
¨?¥³
SQL_Latin1_General_CP1256_CI_AS
¨?¥³
SQL_Latin1_General_CP1256_CS_AS
¨?¥³
SQL_Latin1_General_CP1257_CI_AS
¨??³
SQL_Latin1_General_CP1257_CS_AS
¨??³
SQL_Latin1_General_CP437_BIN
"ª¥3
SQL_Latin1_General_CP437_BIN2
"ª¥3
SQL_Latin1_General_CP437_CI_AI
"ª¥3
SQL_Latin1_General_CP437_CI_AS
"ª¥3
SQL_Latin1_General_CP437_CS_AS
"ª¥3
SQL_Latin1_General_CP850_BIN
¨ª¥³
SQL_Latin1_General_CP850_BIN2
¨ª¥³
SQL_Latin1_General_CP850_CI_AI
¨ª¥³
SQL_Latin1_General_CP850_CI_AS
¨ª¥³
SQL_Latin1_General_CP850_CS_AS
¨ª¥³
SQL_Latin1_General_Pref_CP1_CI_AS
¨ª¥³
SQL_Latin1_General_Pref_CP437_CI_AS
"ª¥3
SQL_Latin1_General_Pref_CP850_CI_AS
¨ª¥³
SQL_Latvian_CP1257_CI_AS
¨??³
SQL_Latvian_CP1257_CS_AS
¨??³
SQL_Lithuanian_CP1257_CI_AS
¨??³
SQL_Lithuanian_CP1257_CS_AS
¨??³
SQL_MixDiction_CP1253_CS_AS
¨?¥³
SQL_Polish_CP1250_CI_AS
¨aY3
SQL_Polish_CP1250_CS_AS
¨aY3
SQL_Romanian_CP1250_CI_AS
¨aY3
SQL_Romanian_CP1250_CS_AS
¨aY3
SQL_Scandinavian_CP850_CI_AS
¨ª¥³
SQL_Scandinavian_CP850_CS_AS
¨ª¥³
SQL_Scandinavian_Pref_CP850_CI_AS
¨ª¥³
SQL_Slovak_CP1250_CI_AS
¨aY3
SQL_Slovak_CP1250_CS_AS
¨aY3
SQL_Slovenian_CP1250_CI_AS
¨aY3
SQL_Slovenian_CP1250_CS_AS
¨aY3
SQL_SwedishPhone_Pref_CP1_CI_AS
¨ª¥³
SQL_SwedishStd_Pref_CP1_CI_AS
¨ª¥³
SQL_Ukrainian_CP1251_CI_AS
????
SQL_Ukrainian_CP1251_CS_AS
????
Gerald Britton, Pluralsight courses
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply