Unicode

FairCom DB Unicode support requires a custom server build enabling this feature. Please contact your nearest FairCom office for current availability options.

DEFAULT_STRING_ENCODING

DEFAULT_STRING_ENCODING <encoding> 

Specifies the server default string encoding for newly created or altered tables and data files. 

Supported <encoding> values include the following:

• utf8 (default) - specifies the modern UTF-8 Unicode encoding used by JSON, web browsers, etc. 
• windows1252 - specifies the Windows-1252 encoding, which was used prior to the adoption of UTF-8 by the Windows 10 operating system. 
• cp437 - specifies the CP437 encoding, which was used by the IBM PC and MS DOS operating systems. 
• latin1 -  specifies the ISO 8859-1 encoding, which was used prior to the adoption of UTF-8 throughout the Americas, Western Europe, Oceania, and much of Africa. 

ICU_LOCALE

ICU_LOCALE <locale string: xx_YY_Variant> 

Where “xx” is the language as specified by ISO-639 (e.g., “fr” for French); ‘Y’ is a country as specified by ISO-3166 (e.g., “fr_CA” for French language in Canada); and the “Variant” portion represents system dependent options.

See Also

ICU_OPTION, LANGUAGE, XTDKSEG_SEG_TYPE, XTDKSEG_SRC_TYPE, XTDKSEG_SRC_SIZE, XTDKSEG_FAILED_DEFAULT_OK

ICU_OPTION

ICU_OPTION  <option>

Where <option> is one of the following:

STRENGTH_PRIMARY
STRENGTH_SECONDARY
STRENGTH_TERTIARY
STRENGTH_QUATERNARY
STRENGTH_IDENTICAL
STRENGTH_DEFAULT
NORM_NONE
NORM_CAN_DECMP
NORM_CMP_DECMP
NORM_CAN_DECMP_CMP
NORM_CMP_DECMP_CAN
NORM_DEFAULT
LOCALE_SYSDEFAULT_NOTOK
LOCALE_FALLBACK_NOTOK
ATTR_FRENCH_ON
ATTR_FRENCH_OFF
ATTR_CASE_ON
ATTR_CASE_OFF
ATTR_DECOMP_ON
ATTR_DECOMP_OFF
ATTR_SHIFTED
ATTR_NONIGNR
ATTR_LOWER
ATTR_UPPER
ATTR_HANGUL

A configuration file may contain many ICU_OPTION entries. Some combinations of entries do not make sense and the behavior is not guaranteed if they are combined. For instance, using both of these entries is inappropriate:

ICU_OPTION             ATTR_LOWER
ICU_OPTION             ATTR_UPPER

See Also

ICU_LOCALE, LANGUAGE, XTDKSEG_SEG_TYPE, XTDKSEG_SRC_TYPE, XTDKSEG_SRC_SIZE, XTDKSEG_FAILED_DEFAULT_OK

LANGUAGE

LANGUAGE

Support the r-tree language feature in an r-tree enabled server. The following arguments are supported:

ENGLISH
ITALIAN
SPANISH
PORTUGUES
SJIS
EUC 

If more than one entry exists in the configuration file, the last occurrence is used.

Note Refer to the Unicode documentation for complete details regarding this support.

See Also

ICU_LOCALE, ICU_OPTION, XTDKSEG_SEG_TYPE, XTDKSEG_SRC_TYPE, XTDKSEG_SRC_SIZE, XTDKSEG_FAILED_DEFAULT_OK

UNCSEG_KEYCOMPRESS

UNCSEG_KEYCOMPRESS YES | NO

Used to force indexes that contain a key segment using a Unicode key segment mode to be created with c-tree leading and padding key compression.

By default, this option is OFF. To enable this option, add the following to ctsrvr.cfg:

This option can also be enabled or disabled at runtime using the ctadmn utility's option to change a server configuration option value or programmatically calling ctSETCFG().

XTDKSEG_SEG_TYPE

XTDKSEG_SEG_TYPE UNICODE_ICU

Specifies a server default for each type of extended segment definition supported.

Example

XTDKSEG_SEG_TYPE         UNICODE_ICU
ICU_LOCALE               "ar"
XTDKSEG_SRC_SIZE         12
XTDKSEG_SRC_TYPE         UTF8
ICU_OPTION               STRENGTH_TERTIARY
ICU_OPTION               NORM_DEFAULT

See Also

ICU_LOCALE, ICU_OPTION, LANGUAGE, XTDKSEG_SRC_TYPE, XTDKSEG_SRC_SIZE, XTDKSEG_FAILED_DEFAULT_OK

XTDKSEG_SRC_TYPE

XTDKSEG_SRC_TYPE <type>

Where <type> is one of:

PROVIDED
UTF8
UTF16

See Also

ICU_LOCALE, ICU_OPTION, LANGUAGE, XTDKSEG_SEG_TYPE, XTDKSEG_SRC_SIZE, XTDKSEG_FAILED_DEFAULT_OK

XTDKSEG_FAILED_DEFAULT_OK

XTDKSEG_FAILED_DEFAULT_OK  <YES | NO>

• YES - Server can still begin if server default encounters an error.
• NO - Server cannot continue on error, which is the default behavior.

See Also

ICU_LOCALE, ICU_OPTION, LANGUAGE, XTDKSEG_SEG_TYPE, XTDKSEG_SRC_TYPE, XTDKSEG_SRC_SIZE