Hey check the MySQL C API By Example site.
http://www.geocities.com/jahan.geo
Yes you have to convert the data always and its zero terminated.
Mads Kristensen wrote:
Hi all.
I'm using the MySQL C API to interface with my MySQL 4.1 server and I
have the following questions:
When I do a SELECT of some integer data value what is actually returned
is a string representation of the integer value and since I need this
integer value in my client I have to convert it. Is it possible to get
MySQL to return the actual integer value instead?
If not, and I actually have to convert the value every time, I have
another related question: Are the values returned zero-terminated? Or do
I have to use the lengths that I can fetch with mysql_fetch_lengths? The
reason that I ask this question is that if the fields are not
zero-terminated I have to copy the values into a temporary buffer,
zero-terminate that buffer and the do the conversion every time...
This seems like a lot of wasted work ;-)
Best regards,
Mads Kristensen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]