webMethods Product Suite  | Complete Installation and Upgrade Information for Software AG Products | Installing Software AG Products | Preparing for Database Component Creation | Database User and Storage, and Database Settings | 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 and can 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.
Copyright © 2007-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.