Function returns different values

Question

Post reply

Function returns different values

yogi123

SSCrazy

Points: 2932
More actions
October 7, 2014 at 1:05 pm

#291310

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

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

g.britton SSChampion Points: 13863 More actions · Answer 1

1. please post the different results

2. is it possible that the remote table was updated between the two queries?

Gerald Britton, Pluralsight courses

yogi123 SSCrazy Points: 2932 More actions · Answer 2

g.britton (10/7/2014)
1. please post the different results
2. 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.

g.britton SSChampion Points: 13863 More actions · Answer 3

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

yogi123 SSCrazy Points: 2932 More actions · Answer 4

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?

g.britton SSChampion Points: 13863 More actions · Answer 5

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

yogi123 SSCrazy Points: 2932 More actions · Answer 6

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

g.britton SSChampion Points: 13863 More actions · Answer 7

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

yogi123 SSCrazy Points: 2932 More actions · Answer 8

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

g.britton SSChampion Points: 13863 More actions · Answer 9

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