Re: blob and substring

2004-07-21 Thread Martin Gainty
http://www.javalobby.org/kb/entry!default.jspa;jsessionid=43D42C7656C249E645485AF43737A12A?categoryID=48&entryID=79&fromSearchPage=true HTH, Martin Gainty From: gerald_clark <[EMAIL PROTECTED]> To: jonathan dumaresq <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: blo

Re: blob and substring

2004-07-21 Thread 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. jon

blob and substring

2004-07-21 Thread jonathan dumaresq
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 a