But then replication would not work.
On Tue, 2 Aug 2005, Octavian Rasnita 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
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218 -
- -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information. If you
have received it in error, purge the message from your system and
notify the sender immediately. Any other use of the email by you
is prohibited.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
