Database Collation - Database Reference Guide - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external

Database Reference Guide

Platform
OnBase
Product
Database Reference Guide
Release
Foundation 23.1
License

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.

CAUTION:

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

Note:

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.

Note:

SQL Server 2012 supplementary (_SC) collations are not supported.

Note:

The SQL Server Japanese_Unicode collation is intended for backwards compatibility with SQL Server 7.0 and is not supported.