[Subject Prev][Subject Next][Thread Prev][Thread Next][Subject Index][Thread Index]

Re: pics in MySQL



make sure the file did not have any double-quotes etc. use addslashes() if u
are using perl or PHP.
else, do something to add a backslash before each double-quote(") and
single-quote(') or any other special SQL character.
----- Original Message -----
From: Linux List <linux-prog@xxxxxxxxx>
To: <linux-india-programmers@xxxxxxxxxxxxxxxxxxxxx>
Sent: Thursday, July 20, 2000 11:16 AM
Subject: Re: [LIP] pics in MySQL


> hi
>   I tried this thing but it did not work.
> It says syntax error at line.
> if i remove the LOAD_FILE thing it works but stores the
> string.
> vinu
> On Tue, 18 Jul 2000 14:24:55 +0500
>  deepak yadav <deepak2000@xxxxxxxxxxxx> wrote:
> > *This message was transferred with a trial version of
> > CommuniGate(tm) Pro*
> > hi
> > i found out how to do that in mysql. use following sql
> > statement for mysql , it may work for u
> >
> > UPDATE table_name SET blob_column=LOAD_FILE("/tmp/picture")
> > WHERE id=1;
> >
> > __________
> > deepak
> >
> > At 7/18/00 1:20:00 PM, you wrote:
> > >Do you have any examples on how to store an image in
> > >binary form.The GUI i am using is Java(jdbc connection)
> > >so tell me how to connect and store the image in
> > >db.
> > >vinu
> > >On Tue, 18 Jul 2000 11:46:27 +0530
> > > Paramdeep Singh <PSingh@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
> > wrote:
> > >> *This message was transferred with a trial version of
> > >> CommuniGate(tm) Pro*
> > >> Yes
> > >> you do have in Oracle.
> > >>
> > >> and exact way of storing depends on the version you
> > are
> > >> using of oracle.
> > >>
> > >> The oldest available oracle version shall support
> > >> LongRaw(upto 2G) binary
> > >> dat.
> > >> and 8 ,8i have sepcial facilities for storing
> > multimedia
> > >> content
> > >>
> > >> Param
> > >>
> > >>
> > >>
> > >> -----Original Message-----
> > >> From: Linux List [mailto:linux-prog@xxxxxxxxx]
> > >> Sent: Tuesday, July 18, 2000 11:45 AM
> > >> To: linux-india-programmers@xxxxxxxxxxxxxxxxxxxxx
> > >> Subject: Re: [LIP] pics in MySQL
> > >>
> > >>
> > >> hi
> > >>   Wanted to ask the same.U have some think like that
> > in
> > >> Oracle.Do you have somethink like that for PostGRESQl.
> > >> I want  to store the images in binary form in the
> > >> database.
> > >> vinu
> > >>
> > >> On Sat, 17 Jun 2000 10:32:27 +0530
> > >>  "Muthu" <muthu@xxxxxxxxxxxxxxxxxx> wrote:
> > >> > *This message was transferred with a trial version
> > of
> > >> > CommuniGate(tm) Pro*
> > >> > Hai deepak,
> > >> >
> > >> >     Use Blob data type to store images.One way of
> > >> > updating the image in
> > >> > datafield is , Open the image file and read chunks
> > of
> > >> > bytes (say 1024) and
> > >> > update the blob datafield.
> > >> >
> > >> > i hope the above information will help you
> > >> >
> > >> > with regards
> > >> > Muthukumar
> > >> >
> > >> > > hi
> > >> > > i want to store pictures in MySQL database. what
> > kind
> > >> > of data type is to
> > >> > be used. and how to go about storing it .
> > >> > > please help . a small code would be very helpful.
> > >> > >
> > >> > > reply soon
> > >> > > bye
> > >> > >
> > >> > >  __ deepak __
> > >> > >
> > >> > > have a great day
> > >> > > ICQ 30662394
> > >> > >
> > >> > > -- Try not to let implementation details sneak
> > into
> > >> > design documents.
> > >> > >
> > >> > >
> > >> >
> -----------------------------------------------------------------------
> > >> > > The LIP mailing list archives are available at:
> > >> > >
http://lists.linux-india.org/cgi-bin/wilma/linux-india-programmers
> > >> >
> > >> >
> > >>
> -----------------------------------------------------------------------
> > >> > For more information on the LIP mailing list see:
> > >> > http://lists.linux-india.org/lists/LIP
> > >>
> > >>
> >
>> -----------------------------------------------------------------------
> > >> For information on this and other Linux India mailing
> > >> lists check out
> > >> http://lists.linux-india.org/
> > >>
> >
>> -----------------------------------------------------------------------
> > >> For more information on the LIP mailing list see:
> > >> http://lists.linux-india.org/lists/LIP
> > >
> > >
> > >-----------------------------------------------------------------------
> > >The LIP mailing list archives are available at:
> > >http://lists.linux-india.org/cgi-bin/wilma/linux-india-programmers
> > >
> > >
> >
> > -----------------------------
> > reply soon
> > bye
> >
> >  __ deepak __
> >
> > have a great day
> > ICQ 30662394
> >
> > -- No program done by an undergrad will work after she
> > graduates.
> >
> >
> > -----------------------------------------------------------------------
> > The LIP mailing list archives are available at:
> > http://lists.linux-india.org/cgi-bin/wilma/linux-india-programmers
>
>
> -----------------------------------------------------------------------
> The LIP mailing list archives are available at:
> http://lists.linux-india.org/cgi-bin/wilma/linux-india-programmers
>