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

[Michael Van Canneyt]

On Mon, 11 Jul 2011, Ludo Brands wrote:

>
>
>> Hmmm... I seem to recall prepare and bind parameters in
>> fcl-db/mySQL component source?.  Are you sure about this?  I
>> really, really, really need double precision data to work.  I
>> know i've used binary binds with Int64 arrays and things well
>> beyond 8 bytes binary. _______________________________________________
>
> I see that the functions and structures are defined in mysql.inc but they
> aren't used anywhere. Parameter values are substituted in the sql string
> that is sent to the db and TConnectionName.PrepareStatement doesn't send
> anything to the db.
> The Oracle component fe. uses bindings.

So does Firebird, and I think postgres, but I'm not sure about the latter.

The reason is that when sqldb was created, MySQL (4.0 or 4.1) didn't support 
parameters yet. Support for this would mean that the mysql connection component 
needs to be rewritten for MySQL 5.0 and higher.

Michael.