MySQL Forums
Forum List  »  Connector/C++

How to fix Error 1406 while using Connector/C++?
Posted by: Water Lin
Date: November 13, 2009 02:20AM

I am using MySQL Connector/C++ as client, but I meet Error code 1406
while I am trying to insert Blob kind of data into MySQL. The long data is stored as std::string my problem, and I convert it to std::istringstream then use setBlob() to insert this data.

The size of Blob I want to insert is 100K. The MySQL server gives me a
error message:
--------------
ERR: Data too long for column 'longstring' at row 1 (MySQL error code:
1406, SQLState: 22001 )
--------------

I am using setBlob() to insert this data. But this still happen. Why?

Thanks

Water Lin

Options: ReplyQuote


Subject
Views
Written By
Posted
How to fix Error 1406 while using Connector/C++?
5936
November 13, 2009 02:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.