OK... I'll take a stab at this one. :-)
Obviously it's not a size issue. If MySQL issued a 1064 then that indicates
a parse error in the query syntax. At this point the column types in the
table have not been considered.
I'm not sure if you can retreive any more information about an error in
MySQL... That is to say that I don't remember either. However, the 1064
error looks like this: "Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR)
Message: %s near '%s' at line %d". So I'm not sure how you could get any
more information than that without actually reproducing the error. There is
a good explanation of how error messages are put together here:
http://dev.mysql.com/doc/mysql/en/Error-handling.html
Is it possible the text you are trying to insert has some characters that
need escaping? ...Like maybe some single quotes or double quotes in the html
email body text? Depending on how you are encapsulating your strings in your
query either could cause a query syntax parse error.
Jim Grill
> I'm re-posting this to the mailing list so that everyone can help and
> everyone can learn from the conversation, either now or in the future (via
> the archive).
>
> If your column's datatype is BLOB, you have a capacity of 65,535
characters,
> which is well above the amount of data that is failing. In that case, the
> datatype does not appear to be the problem.
>
> Perhaps the others on the list can suggest another cause for the problem.
> The only thing that comes to me is looking up the error code that you
> mentioned but I don't remember how to do that.
>
> Rhino
>
> ----- Original Message -----
> From: "ANDREW FLETCHER" <fletchera1@stripped>
> To: "Rhino" <rhino1@stripped>
> Sent: Monday, September 27, 2004 9:04 AM
> Subject: Re: Larger amount of text in a field
>
>
> > Hi Rhino,
> > Strange really cause I applied the field definition as "BLOB", the data
> I'm
> > sending has only around 4,000 characters so it should not be a problem
> then
> > ?
> >
> > Can't understand the syntax error coming up, I will need to do some
> > tinkering unless there is a better way to store data of this type ?
> >
> > Thanks for your help so far. it is much appreciated.
> >
> > Here from you soon I hope,
> > Best regards
> > Andy Fletcher
> > ----- Original Message -----
> > From: "Rhino" <rhino1@stripped>
> > To: "ANDREW FLETCHER" <fletchera1@stripped>;
> <mysql@stripped>
> > Sent: Monday, September 27, 2004 1:35 PM
> > Subject: Re: Larger amount of text in a field
> >
> >
> > > 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
> > >
> > >
> >
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
>
>
>
