Oracle Rdb supports multiple character sets and lets you use more
than one character set in a database. The supported character
sets are:
o ARABIC
o BIG5
o DEC_HANYU
o DEC_HANZI
o DEC_KANJI
o DEC_KOREAN
o DEC_MCS
o DEC_SICGCC
o DEVANAGARI
o DOS_LATIN1
o DOS_LATINUS
o HANYU
o HANZI
o HEX
o ISOLATIN1
o ISOLATIN9
o ISOLATINARABIC
o ISOLATINCYRILLIC
o ISOLATINGREEK
o ISOLATINHEBREW
o KANJI
o KATAKANA
o KOREAN
o SHIFT_JIS
o TACTIS
o WIN_ARABIC
o WIN_CYRILLIC
o WIN_GREEK
o WIN_HEBREW
o WIN_LATIN1
The various ways characters can be coded are:
o Single-octet
A single-octet character set is entirely represented in one
octet. ASCII is an example of a single-octet character set.
Each ASCII character is represented in one octet.
o Multi-octet
A multi-octet character set is, in general, entirely
represented in one or more octets. Some character sets are
fixed multi-octet character sets and some are mixed multi-
octet characters.
- Fixed multi-octet
A fixed multi-octet character set is represented by two
or more fixed number of octets. Kanji is an example of a
fixed multi-octet character set. Each Kanji character is
represented in two octets.
- Mixed multi-octet
A mixed multi-octet character set is represented by one or
more mixed number of octets that allow the use of ASCII and
a fixed multi-octet character set in the same string. DEC_
KANJI is an example of a mixed multi-octet character set.
The ASCII characters are represented in one octet, and the
Kanji characters are represented in two octets.
Additional Information:
explode
extract