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

Unicode

Platform
Perceptive Content
Product
Unicode
Release
Foundation 24.1
License
ft:lastPublication
2024-04-02T13:38:57.399000
ft:locale
en-US

Collation in Microsoft SQL Server databases provides sorting rules, language case, and accent sensitivity properties for data in the language you are using. By default, Perceptive Content uses the Western European based collation. The Unicode SQL Server script does not have a default collation. Before installing Content and configuring the database, you must modify the COLLATE property in the script to use the appropriate language.

For more information about setting the collation property, refer to the Unicode Best Practices Guide Foundations EP2.