In my data structure I have many BLOBs which are not images - so I am hoping
that MySQL can indeed deal with BLOBs ok ?
Andy
On 8/2/05 12:14 PM, "Octavian Rasnita" <orasnita@stripped> wrote:
> Hi,
>
> I think that I have seen many times the advice not to store the images in
> MySQL, but to store them on the hard disk while putting the path to them in
> the database.
> They could be accessed much faster this way.
>
> Teddy
>
>
> ----- Original Message -----
> From: "Gelu Gogancea" <gelu.gogancea@stripped>
> To: "Jay Blanchard" <jay.blanchard@stripped>; "MySQL mailing
> list" <mysql@stripped>
> Sent: Tuesday, August 02, 2005 13:50 PM
> Subject: RE: Question about BLOB
>
>
> Hi,
> Is not the first time when i read this this page.
> So, the conclusion is that until MySQL version 5.0.3 the empty spaces are
> remove if i wish to store the binary data in a table.
> Is not any other solutions?Because for the moment i convert the binary data
> into ASCII(printing ASCII) string,i add slashes after each converted
> character and after all this i store in the BLOB field on the table.And i
> wish to avoid this procedure...wasting a lot of time.
> Thanks,
>
> _____________________________________________________
> G.NET SOFTWARE COMPANY
> SYSTEM INTEGRATOR - AUTOMATION & SOFTWARE DEVELOPER
> http://www.gonetsoftware.com
>
> Permanent e-mail address :
> gelu.gogancea@stripped
> gelu.gogancea@stripped
>
>
> -----Original Message-----
> From: Jay Blanchard [mailto:jay.blanchard@stripped]
> Sent: Monday, 01 August, 2005 8:41 PM
> To: Gelu Gogancea; MySQL mailing list
> Subject: RE: Question about BLOB
>
>
> [snip]
> I have a table with a MEDIUMBLOB field and i wish to store a
> picture(.BMP) which the size is 10622 bytes.But when i look into the
> table i see only 9582 bytes.
> Please, i wish to know for what reason on the table are few bytes than
> original.
> I use MySQL 5.0 - Fedora Core 3
> [/snip]
>
> Have a look here,
> http://dev.mysql.com/doc/mysql/en/blob.html
