RE: update a Blob field using UPDATE

2006-02-11 Thread Kerry Frater
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

Re: update a Blob field using UPDATE

2006-02-03 Thread Gleb Paharenko
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