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 RAW
data, GRAPHIC
fields are stored without modification in whichever column you specify.
The syntax for the GRAPHIC
data type is:
For GRAPHIC
and GRAPHIC
EXTERNAL
, specifying POSITION
(start:end)
gives the exact location of the field in the logical record.
If you specify a length for the GRAPHIC
(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.