U++ forum: Welcome to the forum

truncated double values from mysql [message #25047]

Tue, 09 February 2010 10:21

MatthiasG
Messages: 27
Registered: January 2008
Location: Germany

Promising Member

Hello,

if i set up my system to LC_NUMERIC=de_DE upp uses ',' as decimal point in double values.
the problem is, that the atof() function now also only accepts double values with a ',' as decimal points.
the mysql plugin however also uses atof() to read doubles from the database. but it seems to me, that mysql always returns doubles with '.', not matter what LC_NUMERIC i set.
is it possible, to change the call to atof() in mysql package to ScanDouble(), so that i always get back the right value...

greetings,
Matthias

PS: sorry for my bad english...

Report message to a moderator