The data is in the form of a double-byte character set (DBCS). The Oracle database does not support double-byte character sets; however, SQL*Loader reads them as single bytes. Like
GRAPHIC fields are stored without modification in whichever column you specify.
The syntax for the
GRAPHIC data type is:
(start:end) gives the exact location of the field in the logical record.
If you specify a length for the
(EXTERNAL) data type, however, then you give the number of double-byte graphic characters. That value is multiplied by 2 to find the length of the field in bytes. If the number of graphic characters is specified, then any length derived from
POSITION is ignored. No delimited data field specification is allowed with
GRAPHIC data type specification.