Andras Pal wrote:
Hi,
I've a large table with lots of floats (or doubles) that i want to query
using C API. By default, in C, the rows are returned as a type of char **,
therefore floating numbers are returned as ascii strings. Is it possible
to fetch somehow directly these numbers in their original binary
representation? I know it is architecture-dependent, but if we use
localhost, it won't cause any problem if the result is casted directy to
(float) and/or (double). For our problem, it would be much more efficent
to do the queries this way than the server converts the number to ascii,
the client converts the number againt to binary (on the same machine), and
we do what we want to do after it (which is a simple multiplication, not
as time consuming as two conversions...).
Hi Andras!
Why not have the MySQL server do the computation, if it is a simple
multiplication? Can you post the code you are using so we might suggest
an alternative solution?
Cheers,
--
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Roaming North America, based in Columbus, Ohio
email: [EMAIL PROTECTED] mob: +1 614 406 1267
Are You MySQL Certified? http://www.mysql.com/certification
Got Cluster? http://www.mysql.com/cluster
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
