Azure SQL Database—New Japanese collations available soon
New collations built for the Japanese market will soon be available in Azure SQL Database. Developers building applications for the Japanese market will be able to implement sorting and filtering operations that'll work with Japanese characters by using the latest linguistic rules. The names of new collations will start with Japanese_XJIS_140 or Japanese_Bushu_Kakusu_140 prefixes.
These new collations will support the recognition of Ideographic Variation Selectors (IVS) used in the Japanese language.
There will also be an additional flag called Variation Selector Sensitivity (VSS). This will enable developers to choose whether new comparison rules use the variation selectors or ignore them when text is compared.