MySQL truncate data automatically

Mohammed Adamu

Hi please am facing this issue in MySQL when inserting a data from a textarea field in my form, the data gets truncated and only insert the first character into the database, but if I manually copy the same text it accepts it in the column. I have used vachar 100, 500 etc and text data type but noting seem to work so far.

Am using jQuery to insert into the MySQL database and all the data get inserted except this "Remarks" column which is always truncated.

Please any help will be of great importance.

Thank you

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mukesh Sagar7y ago
The datatype must be varchar(size) not as vachar as mentioned in the query
Jignesh Kumar7y ago
Hi,

Please check you saving query or store procedure for that coulmn. Look at below point if still not resolved share your code for insert logic
Check data type for column while insert query
check datatype of dataacess parameter in C#
check datatype of table column in SQL.