2 messages in com.mysql.lists.mysqlC API row data not matching database ...
FromSent OnAttachments
Hihn Jason14 Jun 2002 10:54 
Paul DuBois14 Jun 2002 11:33 
Subject:C API row data not matching database data
From:Hihn Jason (Jaso@DANFOSS.com)
Date:06/14/2002 10:54:15 AM
List:com.mysql.lists.mysql

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.