Globalization

Globalization includes internationalization and localization. Internationalization can be applied to various languages and regions. Localization fits the language and culture in a specific area as appending the language-specific components. CUBRID supports multilingual collations including Europe and Asia to facilitate the localization.

If you want to know overall information about character data setting, see Configuration Guide for Characters.

If you want to know about charset, collation and locale, see An Overview of Globalization.

For timezone type and realted functions, see Date/Time Types with Timezone. For timezone related system parameters, see Timezone Parameter. If you want to update a timezone information as a new one, timezone library should be recompiled; for details, see Compiling Timezone Library.

If you want to apply the wanted locale to the database, you have to set the locale firstly, then create the database. Regarding this setting, see Locale Setting.

If you want to change the collation or charset specified on the database, specify COLLATE modifier or CHARSET modifier to the column, table, expression, and specify COLLATE modifier or Charset Introducer to the string literal. Regarding this setting, see Collation.

The functions or operators related to strings can work differently by charset and collation. Regarding this, see Operations Requiring Collation and Charset.

• An Overview of Globalization
  • Character data
  • Related Terms
  • Locale Attributes
  • Collation Properties
  • Collation Naming Rules
  • Files For Locale Setting
• Locale Setting
  • Step 1: Selecting a Locale
  • Step 2: Compiling Locale
  • Step 3: Setting CUBRID to Use a Specific Locale
  • Step 4: Creating a Database with the Selected Locale Setting
  • Step 5 (optional): Manually Verifying the Locale File
  • Step 6: Starting CUBRID-Related Processes
  • Synchronization of Database Collations with System Collations
• Collation
  • Charset and Collation of Column
  • Charset and Collation of Tables
  • Charset and Collation of String Literals
  • Charset and Collation of Expressions
  • Charset and Collation of System Data
  • Impact of Charset Specified When Creating DB
  • String literal input and output
  • Contraction and Expansion of Collation
  • Operations Requiring Collation and Charset
  • Collation settings impacting CUBRID features
  • Viewing Collation Information
• Using i18n characters with JDBC
• Timezone Setting
  • Compiling Timezone Library
• Configuration Guide for Characters
  • Locale
  • CHAR and VARCHAR
  • Choosing Charset
  • Choosing Collation
  • Normalization
  • CAST vs COLLATE
• Remark
• Guide for Adding Locales and Collations
  • LDML Calendar Information
  • LDML Numbers information
  • LDML Alphabet
  • LDML Console Conversion
  • LDML Collation