Installer 10.15 | Complete Installation and Upgrade Information for Software AG Products | Installing Software AG Products On Premises | Preparing for Database Component Creation | Prepare for Database Component Creation for All RDBMSs | Character Set and Sort Order | SQL Server
 
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.