Re: blob and substring

[gerald_clark]

You don't say how you retrieved the data or how you are checking the 
size of the returned data, but beware.
Most languages will interperate a byte with a value of zero as the end 
of a string.
Assigning the result to a string, or doing a length() of a returned 
block will give a false answer.

jonathan dumaresq wrote:
hi all,
I try to port some of the mysql  api to a microcontroller and now i wonder
if i miss something.
I try to retreive a blob (256K) in chuck of 1024 bytes. I use the keywork
substring with index 1 and size 1024 and the sql server only return 252
bytes instead of 1024.
I wonder if i can use an alternative way to retrieve my blob.
regards
Jonathan
 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]