What is the definition of the column which is having the problem with the
large amount of data?
Each column type has a maximum size. See
http://dev.mysql.com/doc/mysql/en/String_type_overview.html for the limits.
The most likely cause for your problem is that you are exceeding that limit.
Rhino
----- Original Message -----
From: "ANDREW FLETCHER" <fletchera1@stripped>
To: <mysql@stripped>
Sent: Saturday, September 25, 2004 11:45 AM
Subject: Larger amount of text in a field
I am having a problem with a syntax error which seems to only occur when I
send a very large amount of text to a particular field.
In this case I am creating a Archive sorage area for emails.
If the email happens to be in HTML format from MS outlook client then it
comes with a huge amount of tags etc.
I also test the theory by pasting an entire CV (3850 characters) to an email
and then tried to capture this to a variable and then INsert this to the
MYSQL database and got the same Sytax error 1064.
Can anybody suggest how to get around this or how I should set the field ?
I am useing Mysql 3.23.58 and the Database type I'm using is Myisam
Here from you soon I hope,
Best regards
Andy Fletcher
