stocking pictures in mysql database ?
Hello, How can i stocking pictures in mysql database ? i've tried to open a file as binary, i've replaced ascii(0) by '\O', etc. i've done an 'insert into table set field='datas'' but doesn't work please help me Pierrot - 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
Re: stocking pictures in mysql database ?
Pierrot: Do a search on the archive (http://lists.mysql.com/) for this list ... look for images and blobs ... you should find numerous topics with the info you are looking for. Gerald Jensen - Original Message - From: navarra/mail.satori.fr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 06, 2002 3:57 AM Subject: stocking pictures in mysql database ? Hello, How can i stocking pictures in mysql database ? i've tried to open a file as binary, i've replaced ascii(0) by '\O', etc. i've done an 'insert into table set field='datas'' but doesn't work please help me Pierrot - 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 - 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
Re: stocking pictures in mysql database ?
Hi, You have to use LOAD_FILE() function to load a file into a blob column. See:http://www.mysql.com/doc/en/String_functions.html Gurhan On Fri, 2002-09-06 at 04:57, navarra/mail.satori.fr wrote: Hello, How can i stocking pictures in mysql database ? i've tried to open a file as binary, i've replaced ascii(0) by '\O', etc. i've done an 'insert into table set field='datas'' but doesn't work please help me Pierrot - 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 - 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