Create the Perceptive Content database for a Unicode environment - Create the Perceptive Content database for a Unicode environment - Perceptive Content - Perceptive Content Database Install Guide - Perceptive-Content/Perceptive-Content-Database-Install-Guide/Foundation-26.1/Perceptive-Content-Database-Installation-and-Setup-Guide/Perceptive-Content-Database-prerequisites/Create-a-Microsoft-SQL-Server-INOW-database/Create-the-Perceptive-Content-database-for-a-Unicode-environment - Foundation 26.1 - Foundation 26.1

Perceptive Content Database Installation and Setup Guide
Platform
Perceptive Content
Product
Perceptive Content Database Install Guide
Release
Foundation 26.1
License
ft:lastPublication
2026-04-16T22:31:22.779000
ft:locale
en-US

To create the Perceptive Content database for a Unicode environment and set the SQL Server database default collation, complete the following steps.

  1. Open the Perceptive Content Database SunflowerSS_Unicode.sql creation script.
  2. In SQL Server Management Studio, display a list of all of the supported collations on your system by executing the following SQL query. 
    SELECT * FROM fn_helpcollations() WHERE NAME LIKE '%_CI%' ORDER BY NAME;
  3. At the beginning of the DDL script, locate the following collation property: 
    COLLATE REPLACE_WITH_VALID_COLLATION_NAME
  4. Change the collation property to the appropriate language from the list that you displayed in step 2.

    For example, to set the collation to be generic for western European languages, change the property to the following:

    Latin1_General_100_CI_AS