照合順序一覧 [SQL Server]
SQL Serverにはデータの比較を行う際のルールを照合順序と呼びます。
例えばAとaを同じと見なすのか、異なると見なすのか、等が定義されています。
これは言語ごとに違います。
サポートされている照合順序はsys.fn_helpcollationsで取得可能です。
2012での日本語対応の照合順序は以下のものになります。
見方は以下のURL(2008R2のものですが)が参考になると思います。
https://technet.microsoft.com/ja-jp/library/ms143515.aspx
SELECT Name FROM fn_helpcollations()
WHERE Name LIKE '%JAPANESE%';
Japanese_BIN
Japanese_BIN2
Japanese_CI_AI
Japanese_CI_AI_WS
Japanese_CI_AI_KS
Japanese_CI_AI_KS_WS
Japanese_CI_AS
Japanese_CI_AS_WS
Japanese_CI_AS_KS
Japanese_CI_AS_KS_WS
Japanese_CS_AI
Japanese_CS_AI_WS
Japanese_CS_AI_KS
Japanese_CS_AI_KS_WS
Japanese_CS_AS
Japanese_CS_AS_WS
Japanese_CS_AS_KS
Japanese_CS_AS_KS_WS
Japanese_90_BIN
Japanese_90_BIN2
Japanese_90_CI_AI
Japanese_90_CI_AI_WS
Japanese_90_CI_AI_KS
Japanese_90_CI_AI_KS_WS
Japanese_90_CI_AS
Japanese_90_CI_AS_WS
Japanese_90_CI_AS_KS
Japanese_90_CI_AS_KS_WS
Japanese_90_CS_AI
Japanese_90_CS_AI_WS
Japanese_90_CS_AI_KS
Japanese_90_CS_AI_KS_WS
Japanese_90_CS_AS
Japanese_90_CS_AS_WS
Japanese_90_CS_AS_KS
Japanese_90_CS_AS_KS_WS
Japanese_90_CI_AI_SC
Japanese_90_CI_AI_WS_SC
Japanese_90_CI_AI_KS_SC
Japanese_90_CI_AI_KS_WS_SC
Japanese_90_CI_AS_SC
Japanese_90_CI_AS_WS_SC
Japanese_90_CI_AS_KS_SC
Japanese_90_CI_AS_KS_WS_SC
Japanese_90_CS_AI_SC
Japanese_90_CS_AI_WS_SC
Japanese_90_CS_AI_KS_SC
Japanese_90_CS_AI_KS_WS_SC
Japanese_90_CS_AS_SC
Japanese_90_CS_AS_WS_SC
Japanese_90_CS_AS_KS_SC
Japanese_90_CS_AS_KS_WS_SC
Japanese_Bushu_Kakusu_100_BIN
Japanese_Bushu_Kakusu_100_BIN2
Japanese_Bushu_Kakusu_100_CI_AI
Japanese_Bushu_Kakusu_100_CI_AI_WS
Japanese_Bushu_Kakusu_100_CI_AI_KS
Japanese_Bushu_Kakusu_100_CI_AI_KS_WS
Japanese_Bushu_Kakusu_100_CI_AS
Japanese_Bushu_Kakusu_100_CI_AS_WS
Japanese_Bushu_Kakusu_100_CI_AS_KS
Japanese_Bushu_Kakusu_100_CI_AS_KS_WS
Japanese_Bushu_Kakusu_100_CS_AI
Japanese_Bushu_Kakusu_100_CS_AI_WS
Japanese_Bushu_Kakusu_100_CS_AI_KS
Japanese_Bushu_Kakusu_100_CS_AI_KS_WS
Japanese_Bushu_Kakusu_100_CS_AS
Japanese_Bushu_Kakusu_100_CS_AS_WS
Japanese_Bushu_Kakusu_100_CS_AS_KS
Japanese_Bushu_Kakusu_100_CS_AS_KS_WS
Japanese_Bushu_Kakusu_100_CI_AI_SC
Japanese_Bushu_Kakusu_100_CI_AI_WS_SC
Japanese_Bushu_Kakusu_100_CI_AI_KS_SC
Japanese_Bushu_Kakusu_100_CI_AI_KS_WS_SC
Japanese_Bushu_Kakusu_100_CI_AS_SC
Japanese_Bushu_Kakusu_100_CI_AS_WS_SC
Japanese_Bushu_Kakusu_100_CI_AS_KS_SC
Japanese_Bushu_Kakusu_100_CI_AS_KS_WS_SC
Japanese_Bushu_Kakusu_100_CS_AI_SC
Japanese_Bushu_Kakusu_100_CS_AI_WS_SC
Japanese_Bushu_Kakusu_100_CS_AI_KS_SC
Japanese_Bushu_Kakusu_100_CS_AI_KS_WS_SC
Japanese_Bushu_Kakusu_100_CS_AS_SC
Japanese_Bushu_Kakusu_100_CS_AS_WS_SC
Japanese_Bushu_Kakusu_100_CS_AS_KS_SC
Japanese_Bushu_Kakusu_100_CS_AS_KS_WS_SC
Japanese_Unicode_BIN
Japanese_Unicode_BIN2
Japanese_Unicode_CI_AI
Japanese_Unicode_CI_AI_WS
Japanese_Unicode_CI_AI_KS
Japanese_Unicode_CI_AI_KS_WS
Japanese_Unicode_CI_AS
Japanese_Unicode_CI_AS_WS
Japanese_Unicode_CI_AS_KS
Japanese_Unicode_CI_AS_KS_WS
Japanese_Unicode_CS_AI
Japanese_Unicode_CS_AI_WS
Japanese_Unicode_CS_AI_KS
Japanese_Unicode_CS_AI_KS_WS
Japanese_Unicode_CS_AS
Japanese_Unicode_CS_AS_WS
Japanese_Unicode_CS_AS_KS
Japanese_Unicode_CS_AS_KS_WS
Japanese_XJIS_100_BIN
Japanese_XJIS_100_BIN2
Japanese_XJIS_100_CI_AI
Japanese_XJIS_100_CI_AI_WS
Japanese_XJIS_100_CI_AI_KS
Japanese_XJIS_100_CI_AI_KS_WS
Japanese_XJIS_100_CI_AS
Japanese_XJIS_100_CI_AS_WS
Japanese_XJIS_100_CI_AS_KS
Japanese_XJIS_100_CI_AS_KS_WS
Japanese_XJIS_100_CS_AI
Japanese_XJIS_100_CS_AI_WS
Japanese_XJIS_100_CS_AI_KS
Japanese_XJIS_100_CS_AI_KS_WS
Japanese_XJIS_100_CS_AS
Japanese_XJIS_100_CS_AS_WS
Japanese_XJIS_100_CS_AS_KS
Japanese_XJIS_100_CS_AS_KS_WS
Japanese_XJIS_100_CI_AI_SC
Japanese_XJIS_100_CI_AI_WS_SC
Japanese_XJIS_100_CI_AI_KS_SC
Japanese_XJIS_100_CI_AI_KS_WS_SC
Japanese_XJIS_100_CI_AS_SC
Japanese_XJIS_100_CI_AS_WS_SC
Japanese_XJIS_100_CI_AS_KS_SC
Japanese_XJIS_100_CI_AS_KS_WS_SC
Japanese_XJIS_100_CS_AI_SC
Japanese_XJIS_100_CS_AI_WS_SC
Japanese_XJIS_100_CS_AI_KS_SC
Japanese_XJIS_100_CS_AI_KS_WS_SC
Japanese_XJIS_100_CS_AS_SC
Japanese_XJIS_100_CS_AS_WS_SC
Japanese_XJIS_100_CS_AS_KS_SC
Japanese_XJIS_100_CS_AS_KS_WS_SC
例えばAとaを同じと見なすのか、異なると見なすのか、等が定義されています。
これは言語ごとに違います。
サポートされている照合順序はsys.fn_helpcollationsで取得可能です。
2012での日本語対応の照合順序は以下のものになります。
見方は以下のURL(2008R2のものですが)が参考になると思います。
https://technet.microsoft.com/ja-jp/library/ms143515.aspx
SELECT Name FROM fn_helpcollations()
WHERE Name LIKE '%JAPANESE%';
Japanese_BIN
Japanese_BIN2
Japanese_CI_AI
Japanese_CI_AI_WS
Japanese_CI_AI_KS
Japanese_CI_AI_KS_WS
Japanese_CI_AS
Japanese_CI_AS_WS
Japanese_CI_AS_KS
Japanese_CI_AS_KS_WS
Japanese_CS_AI
Japanese_CS_AI_WS
Japanese_CS_AI_KS
Japanese_CS_AI_KS_WS
Japanese_CS_AS
Japanese_CS_AS_WS
Japanese_CS_AS_KS
Japanese_CS_AS_KS_WS
Japanese_90_BIN
Japanese_90_BIN2
Japanese_90_CI_AI
Japanese_90_CI_AI_WS
Japanese_90_CI_AI_KS
Japanese_90_CI_AI_KS_WS
Japanese_90_CI_AS
Japanese_90_CI_AS_WS
Japanese_90_CI_AS_KS
Japanese_90_CI_AS_KS_WS
Japanese_90_CS_AI
Japanese_90_CS_AI_WS
Japanese_90_CS_AI_KS
Japanese_90_CS_AI_KS_WS
Japanese_90_CS_AS
Japanese_90_CS_AS_WS
Japanese_90_CS_AS_KS
Japanese_90_CS_AS_KS_WS
Japanese_90_CI_AI_SC
Japanese_90_CI_AI_WS_SC
Japanese_90_CI_AI_KS_SC
Japanese_90_CI_AI_KS_WS_SC
Japanese_90_CI_AS_SC
Japanese_90_CI_AS_WS_SC
Japanese_90_CI_AS_KS_SC
Japanese_90_CI_AS_KS_WS_SC
Japanese_90_CS_AI_SC
Japanese_90_CS_AI_WS_SC
Japanese_90_CS_AI_KS_SC
Japanese_90_CS_AI_KS_WS_SC
Japanese_90_CS_AS_SC
Japanese_90_CS_AS_WS_SC
Japanese_90_CS_AS_KS_SC
Japanese_90_CS_AS_KS_WS_SC
Japanese_Bushu_Kakusu_100_BIN
Japanese_Bushu_Kakusu_100_BIN2
Japanese_Bushu_Kakusu_100_CI_AI
Japanese_Bushu_Kakusu_100_CI_AI_WS
Japanese_Bushu_Kakusu_100_CI_AI_KS
Japanese_Bushu_Kakusu_100_CI_AI_KS_WS
Japanese_Bushu_Kakusu_100_CI_AS
Japanese_Bushu_Kakusu_100_CI_AS_WS
Japanese_Bushu_Kakusu_100_CI_AS_KS
Japanese_Bushu_Kakusu_100_CI_AS_KS_WS
Japanese_Bushu_Kakusu_100_CS_AI
Japanese_Bushu_Kakusu_100_CS_AI_WS
Japanese_Bushu_Kakusu_100_CS_AI_KS
Japanese_Bushu_Kakusu_100_CS_AI_KS_WS
Japanese_Bushu_Kakusu_100_CS_AS
Japanese_Bushu_Kakusu_100_CS_AS_WS
Japanese_Bushu_Kakusu_100_CS_AS_KS
Japanese_Bushu_Kakusu_100_CS_AS_KS_WS
Japanese_Bushu_Kakusu_100_CI_AI_SC
Japanese_Bushu_Kakusu_100_CI_AI_WS_SC
Japanese_Bushu_Kakusu_100_CI_AI_KS_SC
Japanese_Bushu_Kakusu_100_CI_AI_KS_WS_SC
Japanese_Bushu_Kakusu_100_CI_AS_SC
Japanese_Bushu_Kakusu_100_CI_AS_WS_SC
Japanese_Bushu_Kakusu_100_CI_AS_KS_SC
Japanese_Bushu_Kakusu_100_CI_AS_KS_WS_SC
Japanese_Bushu_Kakusu_100_CS_AI_SC
Japanese_Bushu_Kakusu_100_CS_AI_WS_SC
Japanese_Bushu_Kakusu_100_CS_AI_KS_SC
Japanese_Bushu_Kakusu_100_CS_AI_KS_WS_SC
Japanese_Bushu_Kakusu_100_CS_AS_SC
Japanese_Bushu_Kakusu_100_CS_AS_WS_SC
Japanese_Bushu_Kakusu_100_CS_AS_KS_SC
Japanese_Bushu_Kakusu_100_CS_AS_KS_WS_SC
Japanese_Unicode_BIN
Japanese_Unicode_BIN2
Japanese_Unicode_CI_AI
Japanese_Unicode_CI_AI_WS
Japanese_Unicode_CI_AI_KS
Japanese_Unicode_CI_AI_KS_WS
Japanese_Unicode_CI_AS
Japanese_Unicode_CI_AS_WS
Japanese_Unicode_CI_AS_KS
Japanese_Unicode_CI_AS_KS_WS
Japanese_Unicode_CS_AI
Japanese_Unicode_CS_AI_WS
Japanese_Unicode_CS_AI_KS
Japanese_Unicode_CS_AI_KS_WS
Japanese_Unicode_CS_AS
Japanese_Unicode_CS_AS_WS
Japanese_Unicode_CS_AS_KS
Japanese_Unicode_CS_AS_KS_WS
Japanese_XJIS_100_BIN
Japanese_XJIS_100_BIN2
Japanese_XJIS_100_CI_AI
Japanese_XJIS_100_CI_AI_WS
Japanese_XJIS_100_CI_AI_KS
Japanese_XJIS_100_CI_AI_KS_WS
Japanese_XJIS_100_CI_AS
Japanese_XJIS_100_CI_AS_WS
Japanese_XJIS_100_CI_AS_KS
Japanese_XJIS_100_CI_AS_KS_WS
Japanese_XJIS_100_CS_AI
Japanese_XJIS_100_CS_AI_WS
Japanese_XJIS_100_CS_AI_KS
Japanese_XJIS_100_CS_AI_KS_WS
Japanese_XJIS_100_CS_AS
Japanese_XJIS_100_CS_AS_WS
Japanese_XJIS_100_CS_AS_KS
Japanese_XJIS_100_CS_AS_KS_WS
Japanese_XJIS_100_CI_AI_SC
Japanese_XJIS_100_CI_AI_WS_SC
Japanese_XJIS_100_CI_AI_KS_SC
Japanese_XJIS_100_CI_AI_KS_WS_SC
Japanese_XJIS_100_CI_AS_SC
Japanese_XJIS_100_CI_AS_WS_SC
Japanese_XJIS_100_CI_AS_KS_SC
Japanese_XJIS_100_CI_AS_KS_WS_SC
Japanese_XJIS_100_CS_AI_SC
Japanese_XJIS_100_CS_AI_WS_SC
Japanese_XJIS_100_CS_AI_KS_SC
Japanese_XJIS_100_CS_AI_KS_WS_SC
Japanese_XJIS_100_CS_AS_SC
Japanese_XJIS_100_CS_AS_WS_SC
Japanese_XJIS_100_CS_AS_KS_SC
Japanese_XJIS_100_CS_AS_KS_WS_SC
コメント 0