The default collation for a SQL Server installation depends on the Windows System Locale for the server on which SQL Server is installed. For a majority of OnBase customers, the Windows System Locale is English (United States), for which the default SQL Server collation is Latin1_General_100_CI_AS.
Database collation should not be modified after tables have been created. Changing the default collation of the database could potentially cause errors and unexpected behavior in the OnBase application. If it is determined that the database collation needs to be modified after the database has been in use for a period of time, contact Technical Support for guidance and assistance.
The following table details recommended SQL Server collations for the supported OnBase languages. Please contact your solution provider to confirm support for a specific collation not listed.
For databases created with OnBase version 14 or higher, for support with ANSI or Unicode database implementations:
Supported Language |
SQL Server Collation |
Windows Code Page |
---|---|---|
English (US) |
Latin1_General_100_CI_AS |
1252 |
English (UK) |
Latin1_General_100_CI_AS |
1252 |
Danish |
Danish_Greenlandic_100_CI_AS |
1252 |
Norwegian |
Norwegian_100_CI_AS |
1252 |
Spanish |
Modern_Spanish_100_CI_AS |
1252 |
Portuguese |
Latin1_General_100_CI_AS |
1252 |
German |
German_PhoneBook_100_CI_AS |
1252 |
French |
French_100_CI_AS |
1252 |
Romanian |
Romanian_100_CI_AS |
1250 |
Russian |
Cyrillic_General_100_CI_AS |
1251 |
Japanese |
Japanese_XJIS_100_CI_AS_KS (see notes) |
932 |
Chinese (P.R.C.) |
Chinese_Simplified_Stroke_Order_100_CI_AS |
936 |
Chinese (Hong Kong) |
Chinese_Traditional_Stroke_Count_100_CI_AS |
950 |
Chinese (Macau) |
Chinese_Traditional_Stroke_Order_100_CI_AS |
950 |
Chinese (Singapore) |
Chinese_Simplified_Pinyin_100_CI_AS |
950 |
Chinese (Taiwan) |
Chinese_Traditional_Bopomofo_100_CI_AS |
950 |
Arabic |
Arabic_100_CI_AS |
1256 |
Dutch |
Latin1_General_100_CI_AS |
1252 |
Finnish |
Finnish_Swedish_100_CI_AS |
1252 |
Hebrew |
Hebrew_100_CI_AS |
1255 |
Korean |
Korean_100_CI_AS |
949 |
Polish |
Polish_100_CI_AS |
1250 |
Swedish |
Finnish_Swedish_100_CI_AS |
1252 |
Thai |
Thai_100_CI_AS |
874 |
Turkish |
Turkish_100_CI_AS |
1254 |
For Japanese collations, the choice of using KS (Kana sensitive) versus KI (Kana insensitive) will depend on the specific needs of the solution. Further information can be found at http://msdn.microsoft.com/en-us/library/ms143726.aspx.
SQL Server 2012 supplementary (_SC) collations are not supported.
The SQL Server Japanese_Unicode collation is intended for backwards compatibility with SQL Server 7.0 and is not supported.