Problem: If you insert or update data whose size is greater than the maximum size defined for the column, an error occurs.
The following table describes the errors that occur when the data size exceeds the column's maximum size (maxlen):
Datatype | Column maximum size | If the data size exceeds maxlen, the result is |
---|---|---|
Binary | Less than 2K | Data is silently truncated in the field |
Binary | Greater than 2K and less than 32K | MobiLink server throws an exception; you see a transaction failure message in ml.log |
Binary | Greater than 32K | You receive a synchronization exception; parameter length mismatch error in SyncResult |
String | Less than 8K | Data is silently truncated in the field |
String | Greater than 8K | You receive a synchronization exception; parameter length mismatch error in SyncResult |
Workaround: Use the client API to verify that the size of data entered by users is within limits. See the Client Object API Cookbook, available on Sybase Unwired Platform Tech Corner at http://www.sybase.com/developer/library/suptechcorner.