Bug #42059 Enclosure characters cause data to large for field error
Submitted: 12 Jan 2009 19:06 Modified: 12 Feb 2009 20:06
Reporter: Brendan Putek Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version:5.1.24-rc-community-log OS:Any
Assigned to: CPU Architecture:Any
Tags: data, enclosed, load, varchar

[12 Jan 2009 19:06] Brendan Putek
When doing a Load Data Infile into a varchar field mysql counts the enclosure characters on the data before stripping them when determining if the data fits into the field length.

How to repeat:
Load a string with a length of 255 into a varchar(255) and enclose it in the enclosure character for the Load Data Infile statement.

Suggested fix:
Strip the enclosure field before determining if the data will fit into the field.
[12 Jan 2009 20:06] Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newer version, 5.1.30, and, in case of the same problem, please, provide a complete test case, with exact CREATE TABLE and LOAD DATA statements.
[13 Feb 2009 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".