Character data types store alphanumeric data in strings. The most common character data type is VARCHAR2, which is the most efficient option for storing character data.
The byte values correspond to the character encoding scheme, generally called a character set. The database character set is established at database creation. Examples of character sets are 7-bit ASCII, EBCDIC, and Unicode UTF-8.
dell emc certification malaysia
The length semantics of character data types are measurable in bytes or characters. The treatment of strings as a sequence of bytes is called byte semantics. This is the default for character data types. The treatment of strings as a sequence of characters is called character semantics. A character is a code point of the database character set.
comptia certification malaysia
See also
- “Character Sets”
- Oracle Database 2 Day Developer’s Guide for a brief introduction to data types
- Oracle Database Development Guide to learn how to choose a character data type
Leave a Reply