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
