I'm using the C API to return a record which has a field that contains (somewhat) binary data. It's been properly mysql_escape_string()ed. I'm using a 3.23.4x server & client.
When I do a: select data into outfile 'out' from table where id='1'; from the mysql client, I get what I expect in the outfile. When I do a mysql_fetch_row() and a row[0] on the same query from within the C API, I get similar but completely different data. The former is ~1800 bytes long, and the latter ~6200 bytes long. Incidentally the data in the outfile contains a good number of the two char sequence 0x91 0x11, but in the C program, it all comes out as 0xCD Anyway, at the end of the data is a plain text sequence that I am trying to extract. I can find it ok, IF the data were there. The CAPI doesn't show it, and that is my major problem. No 0x00s exist in the datastream. I'm really stuck, so I'd really appreciate any help! Thank you! PS. PHP returns the same thing as the C API. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
