sys.fn_helpcollations

code:sql

SELECT

*

FROM

sys.fn_helpcollations()

WHERE

name like 'Japanese%'

ORDER BY

name ASC;

table:retult

name description

Japanese_90_BIN Japanese-90, binary sort

Japanese_90_BIN2 Japanese-90, binary code point comparison sort

(略)

code:select.sql

SELECT

name,

COLLATIONPROPERTY(name, 'CodePage') AS CodePage,

COLLATIONPROPERTY(name, 'LCID') AS LCID,

COLLATIONPROPERTY(name, 'ComparisonStyle') AS ComparisonStyle,

COLLATIONPROPERTY(name, 'Version') AS Version

FROM

sys.fn_helpcollations()

WHERE

name like 'Japanese%'

ORDER BY

name ASC;

table:result

Japanese_90_BIN 932 1041 0 1

Japanese_90_BIN2 932 1041 0 1

Japanese_90_CI_AI 932 1041 196611 1

Japanese_90_CI_AI_KS 932 1041 131075 1

Japanese_90_CI_AI_KS_SC 932 1041 131075 1

Japanese_90_CI_AI_KS_WS 932 1041 3 1

Japanese_90_CI_AI_KS_WS_SC 932 1041 3 1

Japanese_90_CI_AI_SC 932 1041 196611 1

Japanese_90_CI_AI_WS 932 1041 65539 1

Japanese_90_CI_AI_WS_SC 932 1041 65539 1

Japanese_90_CI_AS 932 1041 196609 1

Japanese_90_CI_AS_KS 932 1041 131073 1

Japanese_90_CI_AS_KS_SC 932 1041 131073 1

Japanese_90_CI_AS_KS_WS 932 1041 1 1

Japanese_90_CI_AS_KS_WS_SC 932 1041 1 1

Japanese_90_CI_AS_SC 932 1041 196609 1

Japanese_90_CI_AS_WS 932 1041 65537 1

Japanese_90_CI_AS_WS_SC 932 1041 65537 1

Japanese_90_CS_AI 932 1041 196610 1

Japanese_90_CS_AI_KS 932 1041 131074 1

Japanese_90_CS_AI_KS_SC 932 1041 131074 1

Japanese_90_CS_AI_KS_WS 932 1041 2 1

Japanese_90_CS_AI_KS_WS_SC 932 1041 2 1

Japanese_90_CS_AI_SC 932 1041 196610 1

Japanese_90_CS_AI_WS 932 1041 65538 1

Japanese_90_CS_AI_WS_SC 932 1041 65538 1

Japanese_90_CS_AS 932 1041 196608 1

Japanese_90_CS_AS_KS 932 1041 131072 1

Japanese_90_CS_AS_KS_SC 932 1041 131072 1

Japanese_90_CS_AS_KS_WS 932 1041 0 1

Japanese_90_CS_AS_KS_WS_SC 932 1041 0 1

Japanese_90_CS_AS_SC 932 1041 196608 1

Japanese_90_CS_AS_WS 932 1041 65536 1

Japanese_90_CS_AS_WS_SC 932 1041 65536 1

Japanese_BIN 932 1041 0 0

Japanese_BIN2 932 1041 0 0

Japanese_Bushu_Kakusu_100_BIN 932 263185 0 2

Japanese_Bushu_Kakusu_100_BIN2 932 263185 0 2

Japanese_Bushu_Kakusu_100_CI_AI 932 263185 196611 2

Japanese_Bushu_Kakusu_100_CI_AI_KS 932 263185 131075 2

Japanese_Bushu_Kakusu_100_CI_AI_KS_SC 932 263185 131075 2

Japanese_Bushu_Kakusu_100_CI_AI_KS_WS 932 263185 3 2

Japanese_Bushu_Kakusu_100_CI_AI_KS_WS_SC 932 263185 3 2

Japanese_Bushu_Kakusu_100_CI_AI_SC 932 263185 196611 2

Japanese_Bushu_Kakusu_100_CI_AI_WS 932 263185 65539 2

Japanese_Bushu_Kakusu_100_CI_AI_WS_SC 932 263185 65539 2

Japanese_Bushu_Kakusu_100_CI_AS 932 263185 196609 2

Japanese_Bushu_Kakusu_100_CI_AS_KS 932 263185 131073 2

Japanese_Bushu_Kakusu_100_CI_AS_KS_SC 932 263185 131073 2

Japanese_Bushu_Kakusu_100_CI_AS_KS_WS 932 263185 1 2

Japanese_Bushu_Kakusu_100_CI_AS_KS_WS_SC 932 263185 1 2

Japanese_Bushu_Kakusu_100_CI_AS_SC 932 263185 196609 2

Japanese_Bushu_Kakusu_100_CI_AS_WS 932 263185 65537 2

Japanese_Bushu_Kakusu_100_CI_AS_WS_SC 932 263185 65537 2

Japanese_Bushu_Kakusu_100_CS_AI 932 263185 196610 2

Japanese_Bushu_Kakusu_100_CS_AI_KS 932 263185 131074 2

Japanese_Bushu_Kakusu_100_CS_AI_KS_SC 932 263185 131074 2

Japanese_Bushu_Kakusu_100_CS_AI_KS_WS 932 263185 2 2

Japanese_Bushu_Kakusu_100_CS_AI_KS_WS_SC 932 263185 2 2

Japanese_Bushu_Kakusu_100_CS_AI_SC 932 263185 196610 2

Japanese_Bushu_Kakusu_100_CS_AI_WS 932 263185 65538 2

Japanese_Bushu_Kakusu_100_CS_AI_WS_SC 932 263185 65538 2

Japanese_Bushu_Kakusu_100_CS_AS 932 263185 196608 2

Japanese_Bushu_Kakusu_100_CS_AS_KS 932 263185 131072 2

Japanese_Bushu_Kakusu_100_CS_AS_KS_SC 932 263185 131072 2

Japanese_Bushu_Kakusu_100_CS_AS_KS_WS 932 263185 0 2

Japanese_Bushu_Kakusu_100_CS_AS_KS_WS_SC 932 263185 0 2

Japanese_Bushu_Kakusu_100_CS_AS_SC 932 263185 196608 2

Japanese_Bushu_Kakusu_100_CS_AS_WS 932 263185 65536 2

Japanese_Bushu_Kakusu_100_CS_AS_WS_SC 932 263185 65536 2

Japanese_Bushu_Kakusu_140_BIN 932 263185 0 3

Japanese_Bushu_Kakusu_140_BIN2 932 263185 0 3

Japanese_Bushu_Kakusu_140_CI_AI 932 263185 196611 3

Japanese_Bushu_Kakusu_140_CI_AI_KS 932 263185 131075 3

Japanese_Bushu_Kakusu_140_CI_AI_KS_VSS 932 263185 131075 3

Japanese_Bushu_Kakusu_140_CI_AI_KS_WS 932 263185 3 3

Japanese_Bushu_Kakusu_140_CI_AI_KS_WS_VSS 932 263185 3 3

Japanese_Bushu_Kakusu_140_CI_AI_VSS 932 263185 196611 3

Japanese_Bushu_Kakusu_140_CI_AI_WS 932 263185 65539 3

Japanese_Bushu_Kakusu_140_CI_AI_WS_VSS 932 263185 65539 3

Japanese_Bushu_Kakusu_140_CI_AS 932 263185 196609 3

Japanese_Bushu_Kakusu_140_CI_AS_KS 932 263185 131073 3

Japanese_Bushu_Kakusu_140_CI_AS_KS_VSS 932 263185 131073 3

Japanese_Bushu_Kakusu_140_CI_AS_KS_WS 932 263185 1 3

Japanese_Bushu_Kakusu_140_CI_AS_KS_WS_VSS 932 263185 1 3

Japanese_Bushu_Kakusu_140_CI_AS_VSS 932 263185 196609 3

Japanese_Bushu_Kakusu_140_CI_AS_WS 932 263185 65537 3

Japanese_Bushu_Kakusu_140_CI_AS_WS_VSS 932 263185 65537 3

Japanese_Bushu_Kakusu_140_CS_AI 932 263185 196610 3

Japanese_Bushu_Kakusu_140_CS_AI_KS 932 263185 131074 3

Japanese_Bushu_Kakusu_140_CS_AI_KS_VSS 932 263185 131074 3

Japanese_Bushu_Kakusu_140_CS_AI_KS_WS 932 263185 2 3

Japanese_Bushu_Kakusu_140_CS_AI_KS_WS_VSS 932 263185 2 3

Japanese_Bushu_Kakusu_140_CS_AI_VSS 932 263185 196610 3

Japanese_Bushu_Kakusu_140_CS_AI_WS 932 263185 65538 3

Japanese_Bushu_Kakusu_140_CS_AI_WS_VSS 932 263185 65538 3

Japanese_Bushu_Kakusu_140_CS_AS 932 263185 196608 3

Japanese_Bushu_Kakusu_140_CS_AS_KS 932 263185 131072 3

Japanese_Bushu_Kakusu_140_CS_AS_KS_VSS 932 263185 131072 3

Japanese_Bushu_Kakusu_140_CS_AS_KS_WS 932 263185 0 3

Japanese_Bushu_Kakusu_140_CS_AS_KS_WS_VSS 932 263185 0 3

Japanese_Bushu_Kakusu_140_CS_AS_VSS 932 263185 196608 3

Japanese_Bushu_Kakusu_140_CS_AS_WS 932 263185 65536 3

Japanese_Bushu_Kakusu_140_CS_AS_WS_VSS 932 263185 65536 3

Japanese_CI_AI 932 1041 196611 0

Japanese_CI_AI_KS 932 1041 131075 0

Japanese_CI_AI_KS_WS 932 1041 3 0

Japanese_CI_AI_WS 932 1041 65539 0

Japanese_CI_AS 932 1041 196609 0

Japanese_CI_AS_KS 932 1041 131073 0

Japanese_CI_AS_KS_WS 932 1041 1 0

Japanese_CI_AS_WS 932 1041 65537 0

Japanese_CS_AI 932 1041 196610 0

Japanese_CS_AI_KS 932 1041 131074 0

Japanese_CS_AI_KS_WS 932 1041 2 0

Japanese_CS_AI_WS 932 1041 65538 0

Japanese_CS_AS 932 1041 196608 0

Japanese_CS_AS_KS 932 1041 131072 0

Japanese_CS_AS_KS_WS 932 1041 0 0

Japanese_CS_AS_WS 932 1041 65536 0

Japanese_Unicode_BIN 932 66577 0 0

Japanese_Unicode_BIN2 932 66577 0 0

Japanese_Unicode_CI_AI 932 66577 196611 0

Japanese_Unicode_CI_AI_KS 932 66577 131075 0

Japanese_Unicode_CI_AI_KS_WS 932 66577 3 0

Japanese_Unicode_CI_AI_WS 932 66577 65539 0

Japanese_Unicode_CI_AS 932 66577 196609 0

Japanese_Unicode_CI_AS_KS 932 66577 131073 0

Japanese_Unicode_CI_AS_KS_WS 932 66577 1 0

Japanese_Unicode_CI_AS_WS 932 66577 65537 0

Japanese_Unicode_CS_AI 932 66577 196610 0

Japanese_Unicode_CS_AI_KS 932 66577 131074 0

Japanese_Unicode_CS_AI_KS_WS 932 66577 2 0

Japanese_Unicode_CS_AI_WS 932 66577 65538 0

Japanese_Unicode_CS_AS 932 66577 196608 0

Japanese_Unicode_CS_AS_KS 932 66577 131072 0

Japanese_Unicode_CS_AS_KS_WS 932 66577 0 0

Japanese_Unicode_CS_AS_WS 932 66577 65536 0

Japanese_XJIS_100_BIN 932 1041 0 2

Japanese_XJIS_100_BIN2 932 1041 0 2

Japanese_XJIS_100_CI_AI 932 1041 196611 2

Japanese_XJIS_100_CI_AI_KS 932 1041 131075 2

Japanese_XJIS_100_CI_AI_KS_SC 932 1041 131075 2

Japanese_XJIS_100_CI_AI_KS_WS 932 1041 3 2

Japanese_XJIS_100_CI_AI_KS_WS_SC 932 1041 3 2

Japanese_XJIS_100_CI_AI_SC 932 1041 196611 2

Japanese_XJIS_100_CI_AI_WS 932 1041 65539 2

Japanese_XJIS_100_CI_AI_WS_SC 932 1041 65539 2

Japanese_XJIS_100_CI_AS 932 1041 196609 2

Japanese_XJIS_100_CI_AS_KS 932 1041 131073 2

Japanese_XJIS_100_CI_AS_KS_SC 932 1041 131073 2

Japanese_XJIS_100_CI_AS_KS_WS 932 1041 1 2

Japanese_XJIS_100_CI_AS_KS_WS_SC 932 1041 1 2

Japanese_XJIS_100_CI_AS_SC 932 1041 196609 2

Japanese_XJIS_100_CI_AS_WS 932 1041 65537 2

Japanese_XJIS_100_CI_AS_WS_SC 932 1041 65537 2

Japanese_XJIS_100_CS_AI 932 1041 196610 2

Japanese_XJIS_100_CS_AI_KS 932 1041 131074 2

Japanese_XJIS_100_CS_AI_KS_SC 932 1041 131074 2

Japanese_XJIS_100_CS_AI_KS_WS 932 1041 2 2

Japanese_XJIS_100_CS_AI_KS_WS_SC 932 1041 2 2

Japanese_XJIS_100_CS_AI_SC 932 1041 196610 2

Japanese_XJIS_100_CS_AI_WS 932 1041 65538 2

Japanese_XJIS_100_CS_AI_WS_SC 932 1041 65538 2

Japanese_XJIS_100_CS_AS 932 1041 196608 2

Japanese_XJIS_100_CS_AS_KS 932 1041 131072 2

Japanese_XJIS_100_CS_AS_KS_SC 932 1041 131072 2

Japanese_XJIS_100_CS_AS_KS_WS 932 1041 0 2

Japanese_XJIS_100_CS_AS_KS_WS_SC 932 1041 0 2

Japanese_XJIS_100_CS_AS_SC 932 1041 196608 2

Japanese_XJIS_100_CS_AS_WS 932 1041 65536 2

Japanese_XJIS_100_CS_AS_WS_SC 932 1041 65536 2

Japanese_XJIS_140_BIN 932 1041 0 3

Japanese_XJIS_140_BIN2 932 1041 0 3

Japanese_XJIS_140_CI_AI 932 1041 196611 3

Japanese_XJIS_140_CI_AI_KS 932 1041 131075 3

Japanese_XJIS_140_CI_AI_KS_VSS 932 1041 131075 3

Japanese_XJIS_140_CI_AI_KS_WS 932 1041 3 3

Japanese_XJIS_140_CI_AI_KS_WS_VSS 932 1041 3 3

Japanese_XJIS_140_CI_AI_VSS 932 1041 196611 3

Japanese_XJIS_140_CI_AI_WS 932 1041 65539 3

Japanese_XJIS_140_CI_AI_WS_VSS 932 1041 65539 3

Japanese_XJIS_140_CI_AS 932 1041 196609 3

Japanese_XJIS_140_CI_AS_KS 932 1041 131073 3

Japanese_XJIS_140_CI_AS_KS_VSS 932 1041 131073 3

Japanese_XJIS_140_CI_AS_KS_WS 932 1041 1 3

Japanese_XJIS_140_CI_AS_KS_WS_VSS 932 1041 1 3

Japanese_XJIS_140_CI_AS_VSS 932 1041 196609 3

Japanese_XJIS_140_CI_AS_WS 932 1041 65537 3

Japanese_XJIS_140_CI_AS_WS_VSS 932 1041 65537 3

Japanese_XJIS_140_CS_AI 932 1041 196610 3

Japanese_XJIS_140_CS_AI_KS 932 1041 131074 3

Japanese_XJIS_140_CS_AI_KS_VSS 932 1041 131074 3

Japanese_XJIS_140_CS_AI_KS_WS 932 1041 2 3

Japanese_XJIS_140_CS_AI_KS_WS_VSS 932 1041 2 3

Japanese_XJIS_140_CS_AI_VSS 932 1041 196610 3

Japanese_XJIS_140_CS_AI_WS 932 1041 65538 3

Japanese_XJIS_140_CS_AI_WS_VSS 932 1041 65538 3

Japanese_XJIS_140_CS_AS 932 1041 196608 3

Japanese_XJIS_140_CS_AS_KS 932 1041 131072 3

Japanese_XJIS_140_CS_AS_KS_VSS 932 1041 131072 3

Japanese_XJIS_140_CS_AS_KS_WS 932 1041 0 3

Japanese_XJIS_140_CS_AS_KS_WS_VSS 932 1041 0 3

Japanese_XJIS_140_CS_AS_VSS 932 1041 196608 3

Japanese_XJIS_140_CS_AS_WS 932 1041 65536 3

Japanese_XJIS_140_CS_AS_WS_VSS 932 1041 65536 3