Hi Filipe,
On Thu, 13 Jun 2013 15:59:35 +0100
Filipe Madureira <filipe.madure...@sysdevsolutions.com>
wrote:
Hi,
I have a problem executing a query on a WinCE6 ARM
device.
I use SQlite for years and tested on all types of
devices including WinCE6 ARM and never had a problem.
But I have one problem on particular device that has a
Texas Instruments ARM CPU with WinCE6.
A very simple way to reproduce my problem is:
Create Table t1(c1 DECIMAL(12,3))
Insert Into t1(c1) values(2.55)
Select c1 From t1
I run this "Select" with sqlite3_get_table()
The value I get is "3.,+"
It makes no sense, it is not even a number, and only
happens if the decimal values have a number higher than
5.
This seems to be a problem with this CPU/WinCE version.
I don't know SQLite source code, and it is huge, so can
someone tell me where in the source code the float (or
double, I don't know) value of 2.55 is being converted to
a string to be outputed by sqlite3_get_table()?
Or any hint on how to track the problem?
Note: I copied the database file to my PC and the value
stored there is 2.55, so the problem is retrieving the
value on the device.
I have no solution to offer and you probably thought of it
yourseld too, but the + might be an attempt (rather
superfluous and annoying) to indicate upward rounding
took place.
Does this happen with an ordinary C program too? The
culprit
would be the printf() family as implemented on the
platform.
Can scanf() read this type of numbers?
Regards,
Arjen
DISCLAIMER: This message is intended exclusively for the addressee(s) and may
contain confidential and privileged information. If you are not the intended
recipient please notify the sender immediately and destroy this message.
Unauthorized use, disclosure or copying of this message is strictly prohibited.
The foundation 'Stichting Deltares', which has its seat at Delft, The
Netherlands, Commercial Registration Number 41146461, is not liable in any way
whatsoever for consequences and/or damages resulting from the improper,
incomplete and untimely dispatch, receipt and/or content of this e-mail.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
