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" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > To: "Jay Blanchard" <[EMAIL PROTECTED]>; "MySQL mailing > list" <mysql@lists.mysql.com> > 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 : > [EMAIL PROTECTED] > [EMAIL PROTECTED] > > > -----Original Message----- > From: Jay Blanchard [mailto:[EMAIL PROTECTED] > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]