Displays information about the Oracle Rdb character sets.
Data
Column Name Type Description
RDB$LOWCASE_MAPPING varbyte Segmented string containing
list a 256 byte table used for
lowercasing characters
RDB$UPCASE_MAPPING varbyte Segmented string containing
list a 256 byte table used for
uppercasing characters
RDB$ASSOCIATED_ integer Identifier of the associated
CHARACTER_SET character set
RDB$CHARACTER_SET_ID integer Character set identifier
RDB$CHARACTER_SET_NAME char(31) Character set name
RDB$CHARACTER_WILDCARD integer Character used as wildcard
character
RDB$FLAGS integer Character set flags
RDB$FORM_OF_USE integer Character set form-of-use
indicator
RDB$IDENTIFIER_ integer Character set ID of the
CHARACTER_SET indentifier character set
RDB$MAXIMUM_OCTETS integer Maximum number of octets per
character
RDB$MINIMUM_OCTETS integer Minimum number of octets per
character
RDB$REPERTOIRE integer Character set repertoire
RDB$SPACE_CHARACTER integer Character used as space
RDB$STRING_WILDCARD integer Character used as string
wildcard
RDB$VERSION integer Version number of character
set entry
1 – RDB$REPERTOIRE
Represents the repertoire values for RDB$CHARACTER_SETS
information table.
Value Name Description
0 OTHER Non-specific repertoire
1 LATIN Contains mainly Latin characters
2 JAPANESE Contains mainly Japanese characters
3 SIMPLE_ Contains mainly simplified Chinese
CHINESE characters
4 KOREAN Contains mainly Korean characters
5 OLD_CHINESE Contains mainly traditional Chinese
characters
6 UNIVERSAL Contains universal characters; for
example, UNICODE
7 INDIAN Contains mainly Indian characters
8 ARABIC Contains mainly Arabic characters
9 GREEK Contains mainly Greek characters
10 CYRILLIC Contains mainly Cyrillic characters
11 HEBREW Contains mainly Hebrew characters
2 – RDB$FORM_OF_USE
Represents the form-of-use values for RDB$CHARACTER_SETS
information table.
Value Name Description
0 FIXED_OCTET Fixed octet
1 MIXED_OCTET Mixed octet with DEC_KANJI style
encoding
2 FIXED_NO_UP Fixed octet, no uppercasing allowed
3 MIXED_SS2 As in MIXED_OCTET plus <SS2> as
introducer to alternate single octet
encoding
4 FIXED_UP_G1 Fixed octet, uppercasing only 7-bit
characters
5 MIXED_SS3 As in MIXED_SS2 plus <SS3> as introducer
to alternate double octet encoding
6 FIXED_OTHER Fixed octet, other
7 MIXED_C2CB As in MIXED_OCTET plus hex 'C2CB' as
introducer to alternate double octet
encoding
9 MIXED_TAG Mixed octet with leading tag, compound
string
11 MIXED_SHIFT Mixed octet with coding table shifted;
for example, SHIFT_JIS
3 – RDB$FLAGS
Represents flags for RDB$CHARACTER_SETS information table.
Bit
Position Name Description
0 CONTAINS_ASCII Character set contains 7-bit
ASCII characters
1 SPACE_OCTET_REPEATS All octets of the multi-octet
space character are the same
value