Japanese Collation and Supplementary Characters - Japanese Collation and Supplementary Characters - Perceptive Content - Unicode - Perceptive-Content/Unicode/Foundation-24.1/Unicode/Perceptive-Content-Unicode-Functionality/Collation-and-Environments-using-Microsoft-SQL-Server/Japanese-Collation-and-Supplementary-Characters - Foundation 24.1 - Foundation 24.1

If you are using Unicode for Japanese, keep in mind that the Japanese_ and Japanese_Unicode_ collations do not support supplementary characters correctly, but instead interpret them as replacement characters. However, the following Japanese collations recognize supplementary characters correctly:

• Japanese_90_CI_AS
• Japanese_Bushu_Kakusu_100_ CI_AS
• Japanese_XJIS_100_ CI_AS

When modifying the COLLATE property, ensure that you use a Japanese collation that supports supplementary characters.