12.13 Specifying a character set

A character set is an attribute of character data. A character set has the following three attributes.

The character set that is used when none is specified is called the default character set.

Organization of this section
(1) Effects of defining a character set
(2) Character sets that can be used by HiRDB
(3) Specifying a character set
(4) Notes

(1) Effects of defining a character set

When you define a character set, character string data can be stored in a different character set for each table column. This makes it possible, if EBCDIK is specified as the character set, to retrieve, substitute, and compare character data stored in a database in the collating sequence of VOS3 system character string data when you migrate from a VOS3 system to HiRDB. Specifying UTF-16 as the character set allows retrieval, substitution, and comparison of character data in UTF-16.

(2) Character sets that can be used by HiRDB

The following character sets can be used by HiRDB.

(3) Specifying a character set

Specify the character set in the character data type. For details about formats and rules that apply when specifying character sets, see the manual HiRDB Version 9 SQL Reference.

(4) Notes