Re: Jpg file insertion

[Viorel Dragomir]

Don't do that, if it's possible.
You'll probably slow down the server.

Try to save file in a directory and save to database only the filename. [you
may want to rename the file so you won't overwrite diff pics with the same
name]

vioss

----- Original Message -----
From: "Egor Egorov" <egor.egorov@stripped>
To: <mysql@stripped>
Sent: Friday, July 18, 2003 5:19 PM
Subject: Re: Jpg file insertion


> "Sreesekhar  Palaparthy" <sreesekhar_p@stripped> wrote:
> > Hi,
> >      I want to store jpg files to BLOB field of a table. That
> > table has other fields which are integer and char types. So i
> > tried inserting image using
> > LOAD DATA INTO ...... statement . It got stored , but when i
> > retrieve it back , i'm not able to see the image file.I hope it
> > didn't get stored in proper format. How do i acheieve this ??
>
> You should escape inserted data. Use LOAD_FILE() function instead:
> http://www.mysql.com/doc/en/String_functions.html
>
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
>    __  ___     ___ ____  __
>   /  |/  /_ __/ __/ __ \/ /    Egor Egorov
>  / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@stripped
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
>        <___/   www.mysql.com
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>