Data too long for column... MySQL

Data Abstract
1

Hi,
I have a custom DA delphi server, when I try to apply updates from a IOS client I sometimes get this kind of error.
How can I avoid this ? is there a way to trim automatically the value ?
Regards

2

You can examine “changedRows” property of DADataTable before post changes.
DAFieldDefinition property “properties” is dictionary, for key “Size” it has corresponding value from schema.

3

slavad,
are you talking server side or client side ?
and wich event exactly ?
Regards

4

Hi,

I told about IOS client, unfortunately DARemoteDataAdapterDelegate protocol doesn’t have event before applying update, so need do check manually before call applyChangesForTable, applyChangesForTables methods or it asynchronous equivalents beginApplyChanges*.
On server side you can change fields values if add business processor component (http://wiki.remobjects.com/wiki/Business_Processors_(.NET_and_Delphi) , http://wiki.remobjects.com/wiki/The_Business_Processor_in_Depth_(Delphi)) for corresponding table in event OnBeforeProcessChange. Also you can use OnReadFieldValue event for data streamer component (http://wiki.remobjects.com/wiki/Streamers_(Data_Abstract)).

5

Thanks Slavad