Gelu Gogancea wrote:
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,
the story for the trailing spaces only apply for varchar, so for blob it does not matter as long as you properly escape the data. (you don't need the ascii conversion, just the escaping)
-- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
