AnsweredAssumed Answered

com.mysql.jdbc.MysqlDataTruncation: Data too long for column TEXT at row

Question asked by pushpindersingh on Aug 18, 2014
Latest reply on Aug 19, 2014 by martin.grofcik
Hi All,
We are getting following while saving a json value with varchar size > 65,535 on mysql (version 5.1.x) database
com.mysql.jdbc.MysqlDataTruncation: Data too long for column TEXT at row

I wonder what is right way to fix this problem.

I can think of two way:
1. Changing table ACT_RU_VARIABLE column TEXT_ from varchar(4000) to TEXT
2. Storing json value in some other database outside Activiti database.

I will like to hear how other solved this problem.

Thanks in advance.

Outcomes