Create the Perceptive Content database for a Unicode environment - Perceptive Content Database Install Guide - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

Perceptive Content Database Install Guide

Platform
Perceptive Content
Product
Perceptive Content Database Install Guide
Release
Foundation 24.1
License

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