I use mysql C API and for *escaping* the data i use the mysql_real_escape_string()....the mysql native function. 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: Philippe Poelvoorde [mailto:[EMAIL PROTECTED] Sent: Wednesday, 03 August, 2005 9:58 AM To: 'mysql@lists.mysql.com ' Subject: Re: Question about BLOB 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]