[freetds] Character set problem

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Thu Sep 16 07:36:03 EDT 2004


> 
> > Mmmm... it's a bug of FreeTDS. I'll fix ASAP. 
> > FreeTDS consider only LCID and not sql collation. In this case LCID
> > (0x40b) correspond to CP1252 while your sql collation correspond to
> > CP850.
> 
> OK Thanks. Just wonder why it is me, who always bumps on special 
> problems ;)
> 
> regards hannu
> > 

Here you are post 0.62.4 patch that should solve your problem.

This it's the store procedure I used to extract some informations (part
it's computed from FreeTDS dump and may be useful to someone else)

CREATE PROCEDURE fixcollate AS

SET NOCOUNT ON

CREATE TABLE #tmp3 (name VARCHAR(100), lcid VARCHAR(10), coll INT)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hebrew_BIN','0x40d',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hebrew_CI_AI','0x40d',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hebrew_CI_AI_KS','0x40d',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hebrew_CI_AI_KS_WS','0x40d',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hebrew_CI_AI_WS','0x40d',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hebrew_CI_AS','0x40d',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hebrew_CI_AS_KS','0x40d',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hebrew_CI_AS_KS_WS','0x40d',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hebrew_CI_AS_WS','0x40d',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hebrew_CS_AI','0x40d',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hebrew_CS_AI_KS','0x40d',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hebrew_CS_AI_KS_WS','0x40d',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hebrew_CS_AI_WS','0x40d',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hebrew_CS_AS','0x40d',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hebrew_CS_AS_KS','0x40d',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hebrew_CS_AS_KS_WS','0x40d',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hebrew_CS_AS_WS','0x40d',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP1255_CI_AS','0x409',138)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP1255_CS_AS','0x409',137)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP850_BIN','0x409',40)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP850_CI_AI','0x409',44)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP850_CI_AS','0x409',42)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP850_CS_AS','0x409',41)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_Pref_CP850_CI_AS','0x409',43)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_1xCompat_CP850_CI_AS','0x409',49)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_AltDiction_CP850_CI_AI','0x409',57)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_AltDiction_CP850_CI_AS','0x409',61)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_AltDiction_CP850_CS_AS','0x409',55)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_AltDiction_Pref_CP850_CI_AS','0x409',56)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Scandinavian_CP850_CI_AS','0x40b',60)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Scandinavian_CP850_CS_AS','0x40b',59)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Scandinavian_Pref_CP850_CI_AS','0x40b',58)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Estonian_CP1257_CI_AS','0x425',156)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Estonian_CP1257_CS_AS','0x425',155)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latvian_CP1257_CI_AS','0x426',158)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latvian_CP1257_CS_AS','0x426',157)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Lithuanian_CP1257_CI_AS','0x427',160)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Lithuanian_CP1257_CS_AS','0x427',159)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP1257_CI_AS','0x409',154)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP1257_CS_AS','0x409',153)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Latvian_BIN','0x426',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Latvian_CI_AI','0x426',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Latvian_CI_AI_KS','0x426',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Latvian_CI_AI_KS_WS','0x426',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Latvian_CI_AI_WS','0x426',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Latvian_CI_AS','0x426',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Latvian_CI_AS_KS','0x426',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Latvian_CI_AS_KS_WS','0x426',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Latvian_CI_AS_WS','0x426',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Latvian_CS_AI','0x426',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Latvian_CS_AI_KS','0x426',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Latvian_CS_AI_KS_WS','0x426',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Latvian_CS_AI_WS','0x426',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Latvian_CS_AS','0x426',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Latvian_CS_AS_KS','0x426',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Latvian_CS_AS_KS_WS','0x426',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Latvian_CS_AS_WS','0x426',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Lithuanian_BIN','0x427',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Lithuanian_CI_AI','0x427',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_CI_AI_KS','0x427',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_CI_AI_KS_WS','0x427',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_CI_AI_WS','0x427',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Lithuanian_CI_AS','0x427',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_CI_AS_KS','0x427',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_CI_AS_KS_WS','0x427',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_CI_AS_WS','0x427',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_Classic_BIN','0x827',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_Classic_CI_AI','0x827',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_Classic_CI_AI_KS','0x827',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_Classic_CI_AI_KS_WS','0x827',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_Classic_CI_AI_WS','0x827',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_Classic_CI_AS','0x827',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_Classic_CI_AS_KS','0x827',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_Classic_CI_AS_KS_WS','0x827',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_Classic_CI_AS_WS','0x827',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_Classic_CS_AI','0x827',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_Classic_CS_AI_KS','0x827',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_Classic_CS_AI_KS_WS','0x827',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_Classic_CS_AI_WS','0x827',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_Classic_CS_AS','0x827',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_Classic_CS_AS_KS','0x827',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_Classic_CS_AS_KS_WS','0x827',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_Classic_CS_AS_WS','0x827',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Lithuanian_CS_AI','0x427',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_CS_AI_KS','0x427',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_CS_AI_KS_WS','0x427',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_CS_AI_WS','0x427',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Lithuanian_CS_AS','0x427',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_CS_AS_KS','0x427',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_CS_AS_KS_WS','0x427',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Lithuanian_CS_AS_WS','0x427',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Estonian_BIN','0x425',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Estonian_CI_AI','0x425',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Estonian_CI_AI_KS','0x425',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Estonian_CI_AI_KS_WS','0x425',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Estonian_CI_AI_WS','0x425',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Estonian_CI_AS','0x425',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Estonian_CI_AS_KS','0x425',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Estonian_CI_AS_KS_WS','0x425',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Estonian_CI_AS_WS','0x425',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Estonian_CS_AI','0x425',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Estonian_CS_AI_KS','0x425',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Estonian_CS_AI_KS_WS','0x425',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Estonian_CS_AI_WS','0x425',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Estonian_CS_AS','0x425',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Estonian_CS_AS_KS','0x425',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Estonian_CS_AS_KS_WS','0x425',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Estonian_CS_AS_WS','0x425',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Vietnamese_BIN','0x42a',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Vietnamese_CI_AI','0x42a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Vietnamese_CI_AI_KS','0x42a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Vietnamese_CI_AI_KS_WS','0x42a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Vietnamese_CI_AI_WS','0x42a',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Vietnamese_CI_AS','0x42a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Vietnamese_CI_AS_KS','0x42a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Vietnamese_CI_AS_KS_WS','0x42a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Vietnamese_CI_AS_WS','0x42a',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Vietnamese_CS_AI','0x42a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Vietnamese_CS_AI_KS','0x42a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Vietnamese_CS_AI_KS_WS','0x42a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Vietnamese_CS_AI_WS','0x42a',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Vietnamese_CS_AS','0x42a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Vietnamese_CS_AS_KS','0x42a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Vietnamese_CS_AS_KS_WS','0x42a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Vietnamese_CS_AS_WS','0x42a',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Turkish_BIN','0x41f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Turkish_CI_AI','0x41f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Turkish_CI_AI_KS','0x41f',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Turkish_CI_AI_KS_WS','0x41f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Turkish_CI_AI_WS','0x41f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Turkish_CI_AS','0x41f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Turkish_CI_AS_KS','0x41f',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Turkish_CI_AS_KS_WS','0x41f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Turkish_CI_AS_WS','0x41f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Turkish_CS_AI','0x41f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Turkish_CS_AI_KS','0x41f',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Turkish_CS_AI_KS_WS','0x41f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Turkish_CS_AI_WS','0x41f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Turkish_CS_AS','0x41f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Turkish_CS_AS_KS','0x41f',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Turkish_CS_AS_KS_WS','0x41f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Turkish_CS_AS_WS','0x41f',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP1254_CI_AS','0x41f',130)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP1254_CS_AS','0x41f',129)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_Pref_CP1_CI_AS','0x409',53)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_EBCDIC297_CP1_CS_AS','0x40c',217)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_EBCDIC278_CP1_CS_AS','0x40b',213)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_EBCDIC280_CP1_CS_AS','0x409',214)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_EBCDIC284_CP1_CS_AS','0xc0a',215)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_EBCDIC285_CP1_CS_AS','0x409',216)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Icelandic_Pref_CP1_CI_AS','0x40f',186)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP1_CI_AI','0x409',54)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP1_CI_AS','0x409',52)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP1_CS_AS','0x409',51)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Danish_Pref_CP1_CI_AS','0x406',183)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_EBCDIC037_CP1_CS_AS','0x409',210)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_EBCDIC273_CP1_CS_AS','0x407',211)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_EBCDIC277_CP1_CS_AS','0x406',212)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Traditional_Spanish_CS_AS_WS','0x40a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Traditional_Spanish_CS_AI_WS','0x40a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Traditional_Spanish_CS_AS','0x40a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Traditional_Spanish_CS_AS_KS','0x40a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Traditional_Spanish_CS_AS_KS_WS','0x40a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Traditional_Spanish_CI_AI_WS','0x40a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Traditional_Spanish_CI_AS','0x40a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Traditional_Spanish_CI_AS_KS','0x40a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Traditional_Spanish_CI_AS_KS_WS','0x40a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Traditional_Spanish_CI_AS_WS','0x40a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Traditional_Spanish_CS_AI','0x40a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Traditional_Spanish_CS_AI_KS','0x40a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Traditional_Spanish_CS_AI_KS_WS','0x40a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_SwedishPhone_Pref_CP1_CI_AS','0x40b',184)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_SwedishStd_Pref_CP1_CI_AS','0x40b',185)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Traditional_Spanish_BIN','0x40a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Traditional_Spanish_CI_AI','0x40a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Traditional_Spanish_CI_AI_KS','0x40a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Traditional_Spanish_CI_AI_KS_WS','0x40a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Finnish_Swedish_BIN','0x40b',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Finnish_Swedish_CI_AI','0x40b',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Finnish_Swedish_CI_AI_KS','0x40b',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Finnish_Swedish_CI_AI_KS_WS','0x40b',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Finnish_Swedish_CI_AI_WS','0x40b',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Danish_Norwegian_CS_AS_KS_WS','0x406',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Danish_Norwegian_CS_AS_WS','0x406',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Danish_Norwegian_CI_AS_KS_WS','0x406',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Danish_Norwegian_CI_AS_WS','0x406',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Danish_Norwegian_CS_AI','0x406',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Danish_Norwegian_CS_AI_KS','0x406',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Danish_Norwegian_CS_AI_KS_WS','0x406',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Danish_Norwegian_CS_AI_WS','0x406',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Danish_Norwegian_CS_AS','0x406',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Danish_Norwegian_CS_AS_KS','0x406',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Danish_Norwegian_BIN','0x406',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Danish_Norwegian_CI_AI','0x406',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Danish_Norwegian_CI_AI_KS','0x406',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Danish_Norwegian_CI_AI_KS_WS','0x406',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Danish_Norwegian_CI_AI_WS','0x406',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Danish_Norwegian_CI_AS','0x406',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Danish_Norwegian_CI_AS_KS','0x406',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Finnish_Swedish_CI_AS','0x40b',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Finnish_Swedish_CI_AS_KS','0x40b',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Finnish_Swedish_CI_AS_KS_WS','0x40b',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Finnish_Swedish_CI_AS_WS','0x40b',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Finnish_Swedish_CS_AI','0x40b',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Finnish_Swedish_CS_AI_KS','0x40b',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Finnish_Swedish_CS_AI_KS_WS','0x40b',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Finnish_Swedish_CS_AI_WS','0x40b',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Finnish_Swedish_CS_AS','0x40b',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Finnish_Swedish_CS_AS_KS','0x40b',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Finnish_Swedish_CS_AS_KS_WS','0x40b',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Finnish_Swedish_CS_AS_WS','0x40b',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('French_BIN','0x40c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('French_CI_AI','0x40c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('French_CI_AI_KS','0x40c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('French_CI_AI_KS_WS','0x40c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('French_CI_AI_WS','0x40c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('French_CI_AS','0x40c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('French_CI_AS_KS','0x40c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('French_CI_AS_KS_WS','0x40c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('French_CI_AS_WS','0x40c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('French_CS_AI','0x40c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('French_CS_AI_KS','0x40c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('French_CS_AI_KS_WS','0x40c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('French_CS_AI_WS','0x40c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('French_CS_AS','0x40c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('French_CS_AS_KS','0x40c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('French_CS_AS_KS_WS','0x40c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('French_CS_AS_WS','0x40c',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Georgian_Modern_sort_BIN','0x437',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Georgian_Modern_sort_CI_AI','0x437',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Georgian_Modern_sort_CI_AI_KS','0x437',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Georgian_Modern_sort_CI_AI_KS_WS','0x437',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Georgian_Modern_sort_CI_AI_WS','0x437',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Georgian_Modern_sort_CI_AS','0x437',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Georgian_Modern_sort_CI_AS_KS','0x437',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Georgian_Modern_sort_CI_AS_KS_WS','0x437',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Georgian_Modern_sort_CI_AS_WS','0x437',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Georgian_Modern_sort_CS_AI','0x437',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Georgian_Modern_sort_CS_AI_KS','0x437',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Georgian_Modern_sort_CS_AI_KS_WS','0x437',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Georgian_Modern_sort_CS_AI_WS','0x437',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Georgian_Modern_sort_CS_AS','0x437',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Georgian_Modern_sort_CS_AS_KS','0x437',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Georgian_Modern_sort_CS_AS_KS_WS','0x437',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Georgian_Modern_sort_CS_AS_WS','0x437',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('German_PhoneBook_BIN','0x407',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('German_PhoneBook_CI_AI','0x407',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('German_PhoneBook_CI_AI_KS','0x407',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('German_PhoneBook_CI_AI_KS_WS','0x407',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('German_PhoneBook_CI_AI_WS','0x407',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('German_PhoneBook_CI_AS','0x407',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('German_PhoneBook_CI_AS_KS','0x407',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('German_PhoneBook_CI_AS_KS_WS','0x407',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('German_PhoneBook_CI_AS_WS','0x407',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('German_PhoneBook_CS_AI','0x407',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('German_PhoneBook_CS_AI_KS','0x407',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('German_PhoneBook_CS_AI_KS_WS','0x407',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('German_PhoneBook_CS_AI_WS','0x407',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('German_PhoneBook_CS_AS','0x407',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('German_PhoneBook_CS_AS_KS','0x407',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('German_PhoneBook_CS_AS_KS_WS','0x407',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('German_PhoneBook_CS_AS_WS','0x407',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Modern_Spanish_BIN','0xc0a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Modern_Spanish_CI_AI','0xc0a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Modern_Spanish_CI_AI_KS','0xc0a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Modern_Spanish_CI_AI_KS_WS','0xc0a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Modern_Spanish_CI_AI_WS','0xc0a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Modern_Spanish_CI_AS','0xc0a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Modern_Spanish_CI_AS_KS','0xc0a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Modern_Spanish_CI_AS_KS_WS','0xc0a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Modern_Spanish_CI_AS_WS','0xc0a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Modern_Spanish_CS_AI','0xc0a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Modern_Spanish_CS_AI_KS','0xc0a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Modern_Spanish_CS_AI_KS_WS','0xc0a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Modern_Spanish_CS_AI_WS','0xc0a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Modern_Spanish_CS_AS','0xc0a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Modern_Spanish_CS_AS_KS','0xc0a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Modern_Spanish_CS_AS_KS_WS','0xc0a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Modern_Spanish_CS_AS_WS','0xc0a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Latin1_General_CS_AS_WS','0x409',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Latin1_General_CI_AS_WS','0x409',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Latin1_General_CS_AI','0x409',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Latin1_General_CS_AI_KS','0x409',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Latin1_General_CS_AI_KS_WS','0x409',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Latin1_General_CS_AI_WS','0x409',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Latin1_General_CS_AS','0x409',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Latin1_General_CS_AS_KS','0x409',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Latin1_General_CS_AS_KS_WS','0x409',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Latin1_General_BIN','0x409',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Latin1_General_CI_AI','0x409',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Latin1_General_CI_AI_KS','0x409',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Latin1_General_CI_AI_KS_WS','0x409',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Latin1_General_CI_AI_WS','0x409',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Latin1_General_CI_AS','0x409',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Latin1_General_CI_AS_KS','0x409',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Latin1_General_CI_AS_KS_WS','0x409',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Icelandic_BIN','0x40f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Icelandic_CI_AI','0x40f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Icelandic_CI_AI_KS','0x40f',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Icelandic_CI_AI_KS_WS','0x40f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Icelandic_CI_AI_WS','0x40f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Icelandic_CI_AS','0x40f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Icelandic_CI_AS_KS','0x40f',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Icelandic_CI_AS_KS_WS','0x40f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Icelandic_CI_AS_WS','0x40f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Icelandic_CS_AI','0x40f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Icelandic_CS_AI_KS','0x40f',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Icelandic_CS_AI_KS_WS','0x40f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Icelandic_CS_AI_WS','0x40f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Icelandic_CS_AS','0x40f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Icelandic_CS_AS_KS','0x40f',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Icelandic_CS_AS_KS_WS','0x40f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Icelandic_CS_AS_WS','0x40f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Korean_Wansung_BIN','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_CI_AI','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_CI_AI_KS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_CI_AI_KS_WS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_CI_AI_WS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_CI_AS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_CI_AS_KS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_CI_AS_KS_WS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_CI_AS_WS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_CS_AI','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_Unicode_CS_AI','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_Unicode_CS_AI_KS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_Unicode_CS_AI_KS_WS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_Unicode_CS_AI_WS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_Unicode_CS_AS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_Unicode_CS_AS_KS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_Unicode_CS_AS_KS_WS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_Unicode_CS_AS_WS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_CS_AI_KS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_CS_AI_KS_WS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_CS_AI_WS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_CS_AS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_CS_AS_KS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_CS_AS_KS_WS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_CS_AS_WS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_Unicode_BIN','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_Unicode_CI_AI','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_Unicode_CI_AI_KS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_Unicode_CI_AI_KS_WS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_Unicode_CI_AI_WS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_Unicode_CI_AS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_Unicode_CI_AS_KS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_Unicode_CI_AS_KS_WS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Korean_Wansung_Unicode_CI_AS_WS','0x412',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Arabic_BIN','0x401',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Arabic_CI_AI','0x401',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Arabic_CI_AI_KS','0x401',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Arabic_CI_AI_KS_WS','0x401',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Arabic_CI_AI_WS','0x401',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Arabic_CI_AS','0x401',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Arabic_CI_AS_KS','0x401',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Arabic_CI_AS_KS_WS','0x401',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Arabic_CI_AS_WS','0x401',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Arabic_CS_AI','0x401',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Arabic_CS_AI_KS','0x401',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Arabic_CS_AI_KS_WS','0x401',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Arabic_CS_AI_WS','0x401',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Arabic_CS_AS','0x401',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Arabic_CS_AS_KS','0x401',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Arabic_CS_AS_KS_WS','0x401',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Arabic_CS_AS_WS','0x401',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP1256_CI_AS','0x409',146)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP1256_CS_AS','0x409',145)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP1251_CS_AS','0x409',105)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP1251_CI_AS','0x409',106)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Ukrainian_CP1251_CI_AS','0x422',108)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Ukrainian_CP1251_CS_AS','0x422',107)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Ukrainian_BIN','0x422',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Ukrainian_CI_AI','0x422',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Ukrainian_CS_AS_WS','0x422',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Ukrainian_CS_AS_KS','0x422',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Ukrainian_CS_AS_KS_WS','0x422',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Ukrainian_CS_AI_KS','0x422',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Ukrainian_CS_AI_KS_WS','0x422',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Ukrainian_CS_AI_WS','0x422',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Ukrainian_CS_AS','0x422',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Ukrainian_CI_AI_KS','0x422',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Ukrainian_CI_AI_KS_WS','0x422',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Ukrainian_CI_AI_WS','0x422',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Ukrainian_CI_AS','0x422',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Ukrainian_CI_AS_KS','0x422',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Ukrainian_CI_AS_KS_WS','0x422',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Ukrainian_CI_AS_WS','0x422',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Ukrainian_CS_AI','0x422',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Cyrillic_General_BIN','0x419',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Cyrillic_General_CI_AI','0x419',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Cyrillic_General_CI_AI_KS','0x419',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Cyrillic_General_CI_AI_KS_WS','0x419',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Cyrillic_General_CI_AI_WS','0x419',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Cyrillic_General_CI_AS','0x419',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Cyrillic_General_CI_AS_KS','0x419',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Cyrillic_General_CI_AS_KS_WS','0x419',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Cyrillic_General_CI_AS_WS','0x419',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Cyrillic_General_CS_AI','0x419',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Cyrillic_General_CS_AI_KS','0x419',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Cyrillic_General_CS_AI_KS_WS','0x419',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Cyrillic_General_CS_AI_WS','0x419',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Cyrillic_General_CS_AS','0x419',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Cyrillic_General_CS_AS_KS','0x419',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Cyrillic_General_CS_AS_KS_WS','0x419',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Cyrillic_General_CS_AS_WS','0x419',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Macedonian_CS_AS_WS','0x42f',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Macedonian_CS_AI_WS','0x42f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Macedonian_CS_AS','0x42f',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Macedonian_CS_AS_KS','0x42f',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Macedonian_CS_AS_KS_WS','0x42f',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Macedonian_CI_AI_WS','0x42f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Macedonian_CI_AS','0x42f',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Macedonian_CI_AS_KS','0x42f',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Macedonian_CI_AS_KS_WS','0x42f',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Macedonian_CI_AS_WS','0x42f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Macedonian_CS_AI','0x42f',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Macedonian_CS_AI_KS','0x42f',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Macedonian_CS_AI_KS_WS','0x42f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Macedonian_BIN','0x42f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Macedonian_CI_AI','0x42f',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Macedonian_CI_AI_KS','0x42f',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Macedonian_CI_AI_KS_WS','0x42f',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Greek_CI_AI','0x408',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Greek_CI_AI_KS','0x408',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Greek_CI_AI_KS_WS','0x408',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Greek_CI_AI_WS','0x408',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Greek_CI_AS','0x408',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Greek_CI_AS_KS','0x408',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Greek_CI_AS_KS_WS','0x408',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Greek_CI_AS_WS','0x408',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Greek_CS_AI','0x408',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Greek_CS_AI_KS','0x408',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Greek_CS_AI_KS_WS','0x408',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Greek_CS_AI_WS','0x408',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Greek_CS_AS','0x408',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Greek_CS_AS_KS','0x408',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Greek_CS_AS_KS_WS','0x408',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Greek_CS_AS_WS','0x408',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Greek_BIN','0x408',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_AltDiction_CP1253_CS_AS','0x409',121)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP1253_CI_AI','0x409',124)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP1253_CI_AS','0x409',114)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP1253_CS_AS','0x409',113)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_MixDiction_CP1253_CS_AS','0x409',120)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Polish_CP1250_CI_AS','0x415',88)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Polish_CP1250_CS_AS','0x415',87)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Romanian_CP1250_CI_AS','0x418',90)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Romanian_CP1250_CS_AS','0x418',89)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Slovenian_CS_AS_KS_WS','0x424',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovenian_CS_AS_WS','0x424',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Croatian_CP1250_CI_AS','0x41a',92)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Croatian_CP1250_CS_AS','0x41a',91)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Czech_CP1250_CI_AS','0x405',84)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Czech_CP1250_CS_AS','0x405',83)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP1250_CS_AS','0x409',81)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP1250_CI_AS','0x409',82)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Hungarian_CP1250_CS_AS','0x40e',85)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Hungarian_CP1250_CI_AS','0x40e',86)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Polish_CI_AI_KS','0x415',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Polish_CI_AI_KS_WS','0x415',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Polish_CI_AI_WS','0x415',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Polish_CI_AS','0x415',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Polish_CI_AS_KS','0x415',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Polish_CI_AS_KS_WS','0x415',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Polish_CI_AS_WS','0x415',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Polish_CS_AI','0x415',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Polish_CS_AI_KS','0x415',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Polish_CS_AI_KS_WS','0x415',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Polish_CS_AI_WS','0x415',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Polish_CS_AS','0x415',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Polish_CS_AS_KS','0x415',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Polish_CS_AS_KS_WS','0x415',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Polish_CS_AS_WS','0x415',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Romanian_BIN','0x418',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Romanian_CI_AI','0x418',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Romanian_CI_AI_KS','0x418',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Romanian_CI_AI_KS_WS','0x418',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Romanian_CI_AI_WS','0x418',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Romanian_CI_AS','0x418',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Romanian_CI_AS_KS','0x418',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Romanian_CI_AS_KS_WS','0x418',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Romanian_CI_AS_WS','0x418',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Romanian_CS_AI','0x418',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Romanian_CS_AI_KS','0x418',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Romanian_CS_AI_KS_WS','0x418',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Romanian_CS_AI_WS','0x418',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Romanian_CS_AS','0x418',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Romanian_CS_AS_KS','0x418',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Romanian_CS_AS_KS_WS','0x418',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Romanian_CS_AS_WS','0x418',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovak_BIN','0x41b',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovak_CI_AI','0x41b',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovak_CI_AI_KS','0x41b',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovak_CI_AI_KS_WS','0x41b',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovak_CI_AI_WS','0x41b',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovak_CI_AS','0x41b',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovak_CI_AS_KS','0x41b',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovak_CI_AS_KS_WS','0x41b',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovak_CI_AS_WS','0x41b',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovak_CS_AI','0x41b',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovak_CS_AI_KS','0x41b',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovak_CS_AI_KS_WS','0x41b',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovak_CS_AI_WS','0x41b',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovak_CS_AS','0x41b',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovak_CS_AS_KS','0x41b',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovak_CS_AS_KS_WS','0x41b',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovak_CS_AS_WS','0x41b',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovenian_BIN','0x424',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovenian_CI_AI','0x424',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovenian_CI_AI_KS','0x424',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Slovenian_CI_AI_KS_WS','0x424',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovenian_CI_AI_WS','0x424',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovenian_CI_AS','0x424',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovenian_CI_AS_KS','0x424',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Slovenian_CI_AS_KS_WS','0x424',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovenian_CI_AS_WS','0x424',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovenian_CS_AI','0x424',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovenian_CS_AI_KS','0x424',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Slovenian_CS_AI_KS_WS','0x424',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovenian_CS_AI_WS','0x424',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovenian_CS_AS','0x424',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Slovenian_CS_AS_KS','0x424',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Slovenian_CP1250_CS_AS','0x424',95)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Slovak_CP1250_CS_AS','0x41b',93)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Slovenian_CP1250_CI_AS','0x424',96)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Slovak_CP1250_CI_AS','0x41b',94)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Czech_BIN','0x405',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Czech_CI_AI','0x405',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Czech_CI_AI_KS','0x405',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Czech_CI_AI_KS_WS','0x405',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Czech_CI_AI_WS','0x405',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Czech_CI_AS','0x405',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Czech_CI_AS_KS','0x405',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Czech_CI_AS_KS_WS','0x405',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Czech_CS_AS_WS','0x405',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Czech_CI_AS_WS','0x405',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Czech_CS_AI','0x405',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Czech_CS_AI_KS','0x405',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Czech_CS_AI_KS_WS','0x405',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Czech_CS_AI_WS','0x405',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Czech_CS_AS','0x405',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Czech_CS_AS_KS','0x405',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Czech_CS_AS_KS_WS','0x405',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Croatian_CS_AS_WS','0x41a',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Croatian_CS_AS_KS','0x41a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Croatian_CS_AS_KS_WS','0x41a',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Croatian_CS_AI_KS','0x41a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Croatian_CS_AI_KS_WS','0x41a',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Croatian_CS_AI_WS','0x41a',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Croatian_CS_AS','0x41a',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Croatian_BIN','0x41a',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Croatian_CI_AI','0x41a',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Croatian_CI_AI_KS','0x41a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Croatian_CI_AI_KS_WS','0x41a',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Croatian_CI_AI_WS','0x41a',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Croatian_CI_AS','0x41a',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Croatian_CI_AS_KS','0x41a',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Croatian_CI_AS_KS_WS','0x41a',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Croatian_CI_AS_WS','0x41a',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Croatian_CS_AI','0x41a',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Albanian_CS_AS_WS','0x41c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Albanian_BIN','0x41c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Albanian_CI_AI','0x41c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Albanian_CI_AI_KS','0x41c',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Albanian_CI_AI_KS_WS','0x41c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Albanian_CI_AI_WS','0x41c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Albanian_CI_AS','0x41c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Albanian_CI_AS_KS','0x41c',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Albanian_CI_AS_KS_WS','0x41c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Albanian_CI_AS_WS','0x41c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Albanian_CS_AI','0x41c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Albanian_CS_AI_KS','0x41c',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Albanian_CS_AI_KS_WS','0x41c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Albanian_CS_AI_WS','0x41c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Albanian_CS_AS','0x41c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Albanian_CS_AS_KS','0x41c',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Albanian_CS_AS_KS_WS','0x41c',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hungarian_BIN','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hungarian_CI_AI','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hungarian_CI_AI_KS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Hungarian_CI_AI_KS_WS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hungarian_CI_AI_WS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hungarian_CI_AS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hungarian_CI_AS_KS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Hungarian_CI_AS_KS_WS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hungarian_CI_AS_WS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hungarian_CS_AI','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hungarian_CS_AI_KS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Hungarian_CS_AI_KS_WS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hungarian_CS_AI_WS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hungarian_CS_AS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hungarian_CS_AS_KS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Hungarian_CS_AS_KS_WS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Hungarian_CS_AS_WS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Hungarian_Technical_BIN','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Hungarian_Technical_CI_AI','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Hungarian_Technical_CI_AI_KS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Hungarian_Technical_CI_AI_KS_WS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Hungarian_Technical_CI_AI_WS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Hungarian_Technical_CI_AS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Hungarian_Technical_CI_AS_KS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Hungarian_Technical_CI_AS_KS_WS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Hungarian_Technical_CI_AS_WS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Hungarian_Technical_CS_AI','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Hungarian_Technical_CS_AI_KS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Hungarian_Technical_CS_AI_KS_WS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Hungarian_Technical_CS_AI_WS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Hungarian_Technical_CS_AS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Hungarian_Technical_CS_AS_WS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Hungarian_Technical_CS_AS_KS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Hungarian_Technical_CS_AS_KS_WS','0x40e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Polish_BIN','0x415',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Polish_CI_AI','0x415',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Japanese_BIN','0x411',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Japanese_CI_AI','0x411',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Japanese_CI_AI_KS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Japanese_CI_AI_KS_WS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Japanese_CI_AI_WS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Japanese_CI_AS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Japanese_CI_AS_KS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Japanese_CI_AS_KS_WS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Japanese_CI_AS_WS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Japanese_CS_AI','0x411',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Japanese_CS_AI_KS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Japanese_CS_AI_KS_WS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Japanese_Unicode_CS_AS_KS_WS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Japanese_Unicode_CS_AS_WS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Japanese_Unicode_CS_AI_KS_WS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Japanese_Unicode_CS_AI_WS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Japanese_Unicode_CS_AS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Japanese_Unicode_CS_AS_KS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Japanese_CS_AI_WS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Japanese_CS_AS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Japanese_CS_AS_KS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Japanese_CS_AS_KS_WS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Japanese_CS_AS_WS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Japanese_Unicode_BIN','0x411',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Japanese_Unicode_CI_AI','0x411',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Japanese_Unicode_CI_AI_KS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Japanese_Unicode_CI_AI_KS_WS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Japanese_Unicode_CI_AI_WS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Japanese_Unicode_CI_AS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Japanese_Unicode_CI_AS_KS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Japanese_Unicode_CI_AS_KS_WS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Japanese_Unicode_CI_AS_WS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Japanese_Unicode_CS_AI','0x411',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Japanese_Unicode_CS_AI_KS','0x411',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Chinese_PRC_BIN','0x804',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Chinese_PRC_CI_AI','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_CI_AI_KS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_CI_AI_KS_WS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_CI_AI_WS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Chinese_PRC_CI_AS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_CI_AS_KS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_CI_AS_KS_WS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_CI_AS_WS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Chinese_PRC_CS_AI','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_CS_AI_KS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_CS_AI_KS_WS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_CS_AI_WS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Chinese_PRC_CS_AS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_CS_AS_KS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_CS_AS_KS_WS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_CS_AS_WS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_Stroke_BIN','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_Stroke_CI_AI','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_Stroke_CI_AI_KS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_Stroke_CI_AI_KS_WS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_Stroke_CI_AI_WS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_Stroke_CI_AS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_Stroke_CI_AS_KS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_Stroke_CI_AS_KS_WS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_Stroke_CI_AS_WS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_Stroke_CS_AI','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_Stroke_CS_AI_KS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_Stroke_CS_AI_KS_WS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_Stroke_CS_AI_WS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_Stroke_CS_AS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_Stroke_CS_AS_KS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_Stroke_CS_AS_KS_WS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_PRC_Stroke_CS_AS_WS','0x804',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Bopomofo_BIN','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Bopomofo_CI_AI','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Bopomofo_CI_AI_KS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Bopomofo_CI_AI_KS_WS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Bopomofo_CI_AI_WS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Bopomofo_CI_AS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Bopomofo_CI_AS_KS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Bopomofo_CI_AS_KS_WS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Bopomofo_CI_AS_WS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Bopomofo_CS_AI','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Bopomofo_CS_AI_KS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Bopomofo_CS_AI_KS_WS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Bopomofo_CS_AI_WS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Bopomofo_CS_AS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Bopomofo_CS_AS_KS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Bopomofo_CS_AS_KS_WS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Bopomofo_CS_AS_WS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Stroke_BIN','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Stroke_CI_AI','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Stroke_CI_AI_KS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Stroke_CI_AI_KS_WS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Stroke_CI_AI_WS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Stroke_CI_AS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Stroke_CI_AS_KS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Stroke_CI_AS_KS_WS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Stroke_CI_AS_WS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Stroke_CS_AI','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Stroke_CS_AI_KS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Stroke_CS_AS_KS_WS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Stroke_CS_AS_WS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Stroke_CS_AI_KS_WS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Stroke_CS_AI_WS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Stroke_CS_AS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('Chinese_Taiwan_Stroke_CS_AS_KS','0x404',0)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_Pref_CP437_CI_AS','0x409',33)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP437_BIN','0x409',30)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP437_CI_AI','0x409',34)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP437_CI_AS','0x409',32)
INSERT INTO #tmp3(name,lcid,coll)
VALUES('SQL_Latin1_General_CP437_CS_AS','0x409',31)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Thai_BIN','0x41e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Thai_CI_AI','0x41e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Thai_CI_AI_KS','0x41e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Thai_CI_AI_KS_WS','0x41e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Thai_CI_AI_WS','0x41e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Thai_CS_AS','0x41e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Thai_CS_AS_KS','0x41e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Thai_CS_AS_KS_WS','0x41e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Thai_CS_AS_WS','0x41e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Thai_CI_AS','0x41e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Thai_CI_AS_KS','0x41e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Thai_CI_AS_KS_WS','0x41e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Thai_CI_AS_WS','0x41e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Thai_CS_AI','0x41e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Thai_CS_AI_KS','0x41e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Thai_CS_AI_KS_WS','0x41e',0)
INSERT INTO #tmp3(name,lcid,coll) VALUES('Thai_CS_AI_WS','0x41e',0)

-- insert into mao values(char(0x84),char(0x84),char(0x84))
DECLARE ##mao CURSOR FOR SELECT * FROM ::fn_helpcollations() ORDER BY
name
OPEN ##mao
DECLARE @name varchar(100)
DECLARE @desc varchar(100)
DECLARE @sql varchar(8000)
DECLARE @chksum INT
FETCH NEXT FROM ##mao INTO @name, @desc

CREATE TABLE #tmp1 ([name] VARCHAR(100), chksum INT)
WHILE @@FETCH_STATUS = 0
BEGIN
	IF @name NOT LIKE 'Hindi_%'
	BEGIN
		SELECT @sql = 'SET NOCOUNT ON INSERT INTO #tmp1
VALUES(''' + @name + ''', BINARY_CHECKSUM(convert(nvarchar(512),
convert(varchar(512),
0x202122232425262728292a2b2c2d2e2f303132333435363738393a3b3c3d3e3f404142
434445464748494a4b4c4d4e4f505152535455565758595a5b5c5d5e5f60616263646566
6768696a6b6c6d6e6f707172737475767778797a7b7c7d7e7f808182838485868788898a
8b8c8d8e8f909192939495969798999a9b9c9d9e9fa0a1a2a3a4a5a6a7a8a9aaabacadae
afb0b1b2b3b4b5b6b7b8b9babbbcbdbebfc0c1c2c3c4c5c6c7c8c9cacbcccdcecfd0d1d2
d3d4d5d6d7d8d9dadbdcdddedfe0e1e2e3e4e5e6e7e8e9eaebecedeeeff0f1f2f3f4f5f6
f7f8f9fafbfcfdfeff000102030405060708090a0b0c0d0e0f101112131415161718191a
1b1c1d1e1f) collate ' + @name + ')))'
		EXEC (@sql)
	END
	FETCH NEXT FROM ##mao INTO @name, @desc
END
CLOSE ##mao
DEALLOCATE ##mao

/*
DECLARE ##mao2 CURSOR FOR SELECT name, chksum FROM #tmp1 ORDER BY chksum
OPEN ##mao2
FETCH NEXT FROM ##mao2 INTO @name, @chksum
WHILE @@FETCH_STATUS = 0
BEGIN
	IF @name NOT LIKE 'Hindi_%'
	BEGIN
		SELECT @sql = 'SELECT ''' + @name + ''' AS name,
convert(varchar(4), 0x84) collate ' + @name + ' AS test, ' +
CONVERT(VARCHAR(100), @chksum) + ' AS chksum'
		EXEC (@sql)
	END
	FETCH NEXT FROM ##mao2 INTO @name, @chksum
END
CLOSE ##mao2
DEALLOCATE ##mao2
*/

SELECT t1.name, t2.lcid, t2.coll, t1.chksum FROM #tmp1 t1 INNER JOIN
#tmp3 t2 ON t1.name = t2.name ORDER BY chksum, t1.name
DROP TABLE #tmp3
DROP TABLE #tmp1
GO

freddy77

-------------- next part --------------
A non-text attachment was scrubbed...
Name: post-0.62.4.patch.gz
Type: application/x-gzip
Size: 9115 bytes
Desc: post-0.62.4.patch.gz
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20040916/a6f97ecf/attachment.gz 


More information about the FreeTDS mailing list