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

[Ludo Brands]

> I could understand if you wanted to bring this fact into
> argument over arithmetic and cumulative error.  But the fact 
> is - if I send a double precision data value to a double 
> precision field in the SQL database - that value had better 
> be the same - "bit for bit".  Now if someone is being bit 
> shifty on the conversion - that needs to be a addressed. 

The only way to transfer double as binary data to the server is by using
prepared statements and bound parameters. This is currently not implemented
in fcl. All data are transferred as text to the database and are subject to
conversion errors.

I don't think zeoslib uses prepared statements for mysql either.

Ludo