Public preview: New Japanese collations are available in Azure SQL Database

2016年12月28日

New collations that are built for the Japanese market are available in Azure SQL Database. New Japanese collations enable developers who are building applications for Japanese market to implement sorting and filtering operations that work with Japanese characters by using the latest Japanese linguistic rules. The names of new collations start with Japanese_XJIS_140 or Japanese_Bushu_Kakusu_140 prefixes.

An example of a SQL table with new Japanese collations that are defined in some columns is shown in the following code:

DROP TABLE IF EXISTS dbo.People
GO
CREATE TABLE dbo.People(
    id int primary key identity,

    name nvarchar(50) collate Japanese_XJIS_140_CI_AI_KS,
    surname nvarchar(50) collate Japanese_XJIS_140_CI_AI_WS,
    address nvarchar(200),
    town nvarchar(50) collate Japanese_Bushu_Kakusu_140_CS_AS_VSS

)

New Japanese collations support the recognition of Ideographic Variation Selectors (IVS) that are used in the Japanese language. There is one additional flag (VSS – Variation Selector Sensitivity) that enables developers to choose whether the new comparison rules use or ignore variation selectors when text with the variation selectors is compared.

免費帳戶

免費取得 $200 的 Azure 點數與 12 個月的熱門服務

開始免費使用

Visual Studio

訂閱者每年最多可取得價值達 $1800 的 Azure 服務

立即啟用

啟動

加入 BizSpark 方案並取得免費 Azure 服務

深入了解