SQL Server
Database schemas for SQL Server use nchar data types. SQL Server provides support for UTF-16 through its nchar data types. Since nchar data types are always in UTF-16, you do not have to perform any special database configuration.
Some products, such as Process Engine, require a double-byte character set (DBCS). Choose the most appropriate code page for your environment as a database character set.
The table below lists the character sets and sort order recommended by Software AG.
For | Software AG Recommendation |
Character set | The appropriate encoding for the languages your data is in. |
Nchar character set | UTF-16 |
Sort order | Any case-insensitive collation type. If you do not choose a case-insensitive sort order, you will not be able to create some database components in SQL Server. |
You can check the database configuration using the sp_helpdb database stored procedure.