Database administrator

Installing Microsoft SQL Server

During installation, the Microsoft SQL Server installer program detects the Windows regional setting and sets the Microsoft SQL Server language setting accordingly. Use the regional setting selected by the installation program throughout the entire Microsoft SQL Server installation.

Microsoft does not recommend changing the selected regional setting unless you have to match the regional setting to the collation of another instance of Microsoft SQL Server or to the Windows regional setting of another computer. Localized versions of Microsoft SQL Server are available in French, German, Spanish, Italian, Japanese, Korean, and Simplified and Traditional Chinese.

The collation settings must match the language settings on the system. Searching for other languages that do not match the database collation setting will result in invalid search and sort results.

Installing Oracle server

Create the database using the AL32UTF8 database character set.

The collation settings must match the language settings on the system. Searching for other languages that do not match the database collation setting will result in invalid search and sort results.

Set the regular character set to AL32UTF8. It is not required to set the national character set (NLS_NCHAR_CHARACTERSET) to a specific value. You can take the default. The national character set applies to the data types NCHAR / NVARCHAR2 / NCLOB which the Content Platform Engine does not use.

Installing the Db2 for Linux, UNIX and Windows server

Use the UTF-8 codeset for the Db2® for Linux®, UNIX and Windows database server.

The collation settings must match the language settings on the system. Searching for other languages that do not match the database collation setting will result in invalid search and sort results.