Today, I am working on a website project. This error is found: Data truncation: data too long for column 'dcontent' at Row 1. I checked the following. It is found that the length of the table I inserted into the text box is greater than 65535, that is, the default length of text .. Later, I changed the field type of "DContent" to mediumtext, so that this error will not occur. Therefore, if someone finds this error, do not forget to check whether the size of the entered paragraph below exceeds the specified length.
The error "Data truncation: data too long for column 'dcontent' at Row 1" is displayed. I checked the following on the Internet: Yo is usually caused by two reasons ..
1. The length of the field DContent is insufficient ..
For the solution, refer to what I mentioned above.
2. This may also be caused by inconsistent default codes of JSP pages, backend and database. For specific solutions, refer to the following website...
Http://idealpark.spaces.live.com/Blog/cns! 5c74a0cce6e6a884! 245. Entry
Http://hi.baidu.com/overmindgc/blog/item/c0c768062ab86b7e03088166.html