Bulk Copy Values Processing

The guidelines that are applicable for character, numeric, date, and binary datatype values.

Warning! The DirectConnect server cannot correctly transfer varchar values that contain empty strings (zero length non null strings), in the bulk-copy transfer process. Empty string varchar values are interpreted as NULL values.

Character Datatypes
Character datatypes (CHAR, VARCHAR, TEXT) can be converted to any other datatype.
Numeric Datatypes
Numeric datatypes can be converted to other numeric datatypes or to character datatypes, but they cannot be converted to binary or date datatypes.
Date Datatypes
Date datatypes can be converted to other date datatypes or to character strings.
Binary Datatypes
Binary datatypes can be converted to other binary datatypes or to character datatypes.

Parent topic: Bulk-Copy Transfer and Express Transfer

Created November 29, 2012. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com