it into the
BLOB field using LOAD_FROM_FILE.
Slower I know but I get no errors.
Kerry
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: 03 February 2006 11:28
To: mysql@lists.mysql.com
Subject: Re: update a Blob field using UPDATE
Hello.
Have you applied
Hello.
Have you applied mysql_real_escape_string to your BLOB variable first?
See:
http://dev.mysql.com/doc/refman/5.0/en/mysql-real-escape-string.html
I do not see the quotes around mystring$ as well.
Kerry Frater wrote:
I am importing data from a non MySQL table into MySQL.
In the
I am importing data from a non MySQL table into MySQL.
In the table there is a text field of up to length 4000 chars. I have
defined the column as blob in the MySQL table.
I can read the text field of the source table into a variable e.g.
mystring$. The MySQL table has been set, except for this