How to insert a picture into a blob field

ST, Tuesday, January 22, 2002, 8:14:36 AM, you wrote: SO> How can I insert a picture into blob field of a database? You can, but use longblob (probably your picture will be bigger than a usual blob data type) and don't forget to escape special chars in your query. See http://www.mysql.com/doc

Re: How to insert a picture into a blob field

Hi You can use load_file() such as sql="insert into xxx (fld_blob) values (load_file('xxx.jpg')" Kittiphum Worachat ,MT. www.hatyailab.com > How can I insert a picture into blob field of a database? > > Thanks > > ST Ooi > Malaysia > > > ---

How to insert a picture into a blob field

How can I insert a picture into blob field of a database? Thanks ST Ooi Malaysia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To req