Configuring Unicode for SQL Server databases

Each database in your HCL Connections deployment must be configured for Unicode. This procedure must be completed before you install HCL Connections because you cannot configure the database Unicode collation after installation.

Before you begin

You must use the Latin1_General_BIN collation for Unicode handling in Connections. The collation must be set during installation because it cannot be modified after installation.

Procedure

  1. Find the option for changing the collation order.
    • SQL Server 2016

      During setup, on the Server Configuration page, click Collation and then click the Windows collation designator and sort order option.

  2. Select Latin1_General.
  3. Select the Binary option to make Latin1_General_BIN the default collation.