5 Dec
2011
5 Dec
'11
3:28 a.m.
Hello, When storing a string that is longer then the table definition, is it possible to configure mysql to treat this condition as an error and abort the operation, rather then blindly truncating/corrupting the data and reporting a warning? Or does this require using transactions[1]? I thought I saw a solution somewhere ages ago, but can't find it right now. Thanks Notes: [1] IIRC transaction support requires InnoDB and some applications require MyISAM - e.g. for geospatial stuff. Of course another option would be to switch to a better DB, eg postgresql. -- Brian May <brian@microcomaustralia.com.au>