Andras Pal wrote:
> 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...).
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?
Community Relations Manager, North America, MySQL Inc.
Roaming North America, based in Columbus, Ohio
email: jay@stripped mob: +1 614 406 1267
Are You MySQL Certified? http://www.mysql.com/certification
Got Cluster? http://www.mysql.com/cluster