The following guidelines apply to 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.