[fpc-devel] MySQL 5.1 and Double (trouble)

[Hans-Peter Diettrich]

Ludo Brands schrieb:

> But that won't solve the writing of truncated data as long as doubles 
> are passed as a string to mysql.

Right. When the actual DB interface doesn't allow to transfer floating 
point values as binary numbers, you should fall back to storing such 
numbers as text, with the required number of digits, or (safer) as 
binary BLOBs. Then you can store even Extended values instead of only 
Doubles.

Both workarounds may not be compatible with other applications, that 
expect numbers stored in the DB-specific number format.

DoDi