On 5 May 2010 12:55, Piotr Pokora <[email protected]> wrote: > Stian Skjelstad pisze: > >>> I checked new_row_from_mysql_stmt and for G_TYPE_FLOAT and G_TYPE_DOUBLE >>> case, mysql_bind_result[i].buffer is always 0,0000. >>> >>> column is: `created` float NOT NULL DEFAULT '0', >>> >>> Do I miss anything while getting data? >> Just trowing in a quick-question just to check one thing. Is your local >> language set to a language which uses "," as decimal mark? > > I am not sure if this is the case. > GDA sets locale to be always C for floating types. > So floats are stored with dot as decimal in MySQL table. > Which is correct. > > On data fetching there's locale change too, but point is, MySQL buffer > holds invalid (seems so) data. I used to use MySQL C API, and never had > such problem. Though, I have never used prepared statements. > > I wonder if gda_mysql_provider_statement_execute prepare statement > correctly. Neither float nor double is taken into account in this routine.
I've found the problem: I thought float and double could be handled with the same code, which was wrong. I've committed a correction for that in git/master. It seems to work correctly now for both FLOAT and DOUBLE types. Please let me know if you have any more problem. Vivien _______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
