Hello.
On Sun 2002-08-18 at 17:03:03 +0200, [EMAIL PROTECTED] wrote:
> I belive that I have a little bit bigger problem with MySQL, and for now, no
> one told
> me a solution. Problem is with BLOB fields. That type of field behaves OK if
> I use INSERT INTO statement. But the problem is that it is impossible to use
> INSERT INTO when I need to send a string full of binary characters I.E.
> picture, EXE etc. The only solution is to open that kind of file, place it
> in a variable, use ADO and with help of .AddNew mthod to write that variable
> to the database. Result: Multiple-step operation generated errors - error.
> Have You ever met this kind of problem. I have noticed that BLOB fields are
> not so attractive to work with. Are they reliable enough for work because
> whenever I try to work with this data type, I always have difficulties in
> combination with ADO, and seemingly, ADO has not got problems in work. If
> You can help me, I'd appreciate it.
>From MySQL's point of view, BLOBs are as reliable as any other field
type. Have you made sure that you escape special characters correctly
(but whatever means is typical in your programming language, for the C
API, it's mysql_read_escape_string())? If so, it is far more probable
that the reliably issues are not with MySQL but with some component in
between.
But as I said, make sure your that you escape everything correctly,
first.
Regards,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
