Collations based on the Unicode Collation Algorithm of the Unicode Standard version 4.0.0 have been deprecated

Details

When you create Unicode databases, you can specify locale-sensitive collations based on the Unicode Collation Algorithm (UCA) with the COLLATE USING parameter in the CREATE DATABASE command. These collations provide similar functionality and better performance

Resolution

For new Unicode databases, create them using any of the supported locale-sensitive UCA-based collations. See "Unicode Collation Algorithm based collations" for details.

For existing Unicode databases, you can convert to a supported locale-sensitive UCA-based collation by recreating your databases following a similar procedure described in the "Converting non-Unicode databases to Unicode" task.