When a value whose datatype is a Java-SQL object type is transferred from Adaptive Server to a client, the data conversion of the object depends on the client type:
If the client is an isql client, the toString( ) or similar method of the object is invoked and the result is truncated to varchar, which is transferred to the client.
The number of bytes transferred to the client is dependent on the value of the @@stringsize global variable. The default value is 50 bytes. See “Representing Java instances” for more information.
If the client is a Java client that uses jConnect 4.0 or later, the server transmits the object serialization to the client. This serialization is seamlessly deserialized by jConnect to yield a copy of the object.
If the client is a bcp client:
If the object is a column declared as in row, the serialized value contained in the column is transferred to the client as a varbinary value of length determined by the size of the column.
Otherwise, the serialized value of the object (the result of the writeObject method of the object) is transferred to the client as an image value.