gerald
It appears your problem is reading in blob columns is possibly exhausting resources
I would suggest you read in more fine-grained (smaller) chunks
Here is some sample code for you to use
Start the chunking size at your requested size and then attenuate the size by 1/2 with each iteration
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: blob and substring
Date: Wed, 21 Jul 2004 08:30:35 -0500
MIME-Version: 1.0
Received: from lists.mysql.com ([213.136.52.31]) by mc8-f17.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Wed, 21 Jul 2004 06:34:58 -0700
Received: (qmail 17675 invoked by uid 109); 21 Jul 2004 13:30:53 -0000
Received: (qmail 17621 invoked from network); 21 Jul 2004 13:30:51 -0000
Received: neutral (lists.mysql.com: local policy)
X-Message-Info: JGTYoYF78jGca7nPXK21hPJQflK2tELl
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
List-ID: <mysql.mysql.com>
Precedence: bulk
List-Help: <mailto:[EMAIL PROTECTED]>
List-Unsubscribe: <mailto:[EMAIL PROTECTED]>
List-Post: <mailto:[EMAIL PROTECTED]>
List-Archive: http://lists.mysql.com/mysql/169421
Delivered-To: mailing list [EMAIL PROTECTED]
Message-ID: <[EMAIL PROTECTED]>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0
X-Accept-Language: en-us, en
References: <[EMAIL PROTECTED]>
X-Virus-Checked: Checked
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 21 Jul 2004 13:34:59.0114 (UTC) FILETIME=[848828A0:01C46F27]
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]
_________________________________________________________________
Overwhelmed by debt? Find out how to ‘Dig Yourself Out of Debt’ from MSN Money. http://special.msn.com/money/0407debt.armx
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
