Text and Image Data
The DB Access Module for Sybase sends text and image data over a certain data limit as literal strings. This is necessary because the underlying Sybase Open Client Client-Library does not support direct binding of text and image data for single row inserts. The data limit is 16384 bytes for Sybase Open Client.
For bulk inserts, text and image data are sent by direct binding of program variables, since the Sybase Client-Library supports all types for bulk binding.
When fetching data, for better performance it is recommended that text or image data be placed in the last column of the result set. Text and image data are retrieved using the Sybase methods ct_get_data() if the data is in the last column of the result set, and ct_bind() if not.
NOTE: Place text and image data in the last column of the result set for better performance.