Attached is the patch to fix the data truncation issue when updating the data of the type character with length. To fix this issue I have created a ignore type cast list, where while inserting/updating we ignore the typecasting for the mentioned data type.