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 :
gelu.gogancea@stripped
gelu.gogancea@stripped
-----Original Message-----
From: Philippe Poelvoorde [mailto:philippe@stripped]
Sent: Wednesday, 03 August, 2005 9:58 AM
To: 'mysql@stripped '
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/mysql?unsub=1
