I've got a web app in ColdFusion feeding a MySQL 5 database. I'm getting inconsistent errors when doing inserts -- inconsistent in that it is not always throwing an error. When it does throw an error, the error is
Data truncation: Data truncated for column 'COLUMN_NAME'
I've Googled around and suspect this might be a case where I need to set the JDBC driver with a parameter reading
However, other searches come up with folks saying this does not help them. My question is twofold. First, if I'm running MySQL 5.0.19, should I be looking for a patch or upgrade?
Second, can anyone point me to a workaround that would not necessitate a db patch/upgrade?