Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How to fix Error 1406 while using Connector/C++?
0 views
Skip to first unread message
Water Lin
Nov 13, 2009, 3:20:36 AM11/13/09
to
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 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
--
Water Lin's notes and pencils: http://en.waterlin.org
Email: Wate...@ymail.com
toby
Nov 13, 2009, 10:45:41 AM11/13/09
to
On Nov 13, 3:20 am, Water Lin <Water...@ymail.invalid> wrote:
> 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 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?
> 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 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?
What is the actual type of the column?
>
> Thanks
>
> Water Lin
>
> --
> Water Lin's notes and pencils:http://en.waterlin.org
> Email: Water...@ymail.com
0 new messages