Data for the following data types is stored in native operating system binary format and can be written to data files directly in that format. Sybase IQ reads the respective number of bytes directly into the associated data types without conversion.
BIT (1 byte)
TINYINT (1 byte)
SMALLINT (2 bytes)
INT/UNSIGNED INT (4 bytes)
BIGINT/UNSIGNED BIGINT (8 bytes)
FLOAT (4 bytes)
DOUBLE (8 bytes)
CHAR/VARCHAR (character data)
BINARY/VARBINARY (binary data)
By default, VARCHAR and VARBINARY columns are read in as many bytes as specified by LOAD TABLE column-spec.
