Text Data Types

The text data types described in Table 2-3, "OLAP DML Text Data Types" are supported by Oracle OLAP.

Table 2-3 OLAP DML Text Data Types

Data Type	Data Value
`TEXT`	Up to 4000 bytes for each line in the database character set. This data type is equivalent to the `CHAR` and `VARCHAR2` data types in the database.
`NTEXT`	Up to 4000 bytes for each line in UTF-8 character encoding. This data type is equivalent to the `NCHAR` and `NVARCHAR2` data types in the database.
`ID`	Up to 8 single-byte characters for each line in the database character set. (`ID` is valid only for values of simple dimensions, see DEFINE DIMENSION (simple).)

Literals

Enclose text literals in single quotes. Oracle OLAP recognizes unquoted alpha-numeric values as object names and double quotes as the beginning of a comment.

Escape Sequences

Table 2-4, "Recognized Escape Sequences" shows escape sequences that are recognized by Oracle OLAP.

Table 2-4 Recognized Escape Sequences

Sequence	Meaning
`\b`	Backspace
`\f`	Form feed
`\n`	Line feed
`\r`	Carriage return
`\t`	Horizontal tab
`\"`	Double quote
`\'`	Single quote
`\\`	Backslash
`\d`nnn	Character with ASCII code nnn decimal, where \`d` indicates a decimal escape and nnn is the decimal value for the character
`\x`nn	Character with ASCII code nn hexadecimal, where `\x` indicates a hexadecimal escape and nn is the hexadecimal value for the character
`\U`nnnn	Character with Unicode nnnn, where `\U` indicates a Unicode escape and nnnn is a four-digit hexadecimal `INTEGER` that represents the Unicode codepoint with the value `U`+nnnn. The `U` must be a capital letter.