Hi,

I am trying to copy a GIF file to a blob field of a mysql table.

for this the mysql documentation says,

If you want to insert binary data into a blob the following characters must
be represented by escape sequences:
\0 ASCII 0. Should be replaced with "\0" (A backslash and a 0 digit).
\  ASCII 92, backslash
' ASCII 39, Single quote
" ASCII 33, Double quote

One doesn't have to escape " inside ' and " inside '.

If you write C code you can use the C API function mysql_escape_string(char
*to,char *from,uint length) to escape characters for the INSERT clause. In
Perl you can use the quote function.

I could not succeed to place the GIF into the blob. Is it possible? Can some
one guide me to complete the task.

Thanks in advance.

Jacob Joseph.

_______________________________________________
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users

Reply via email to