Error with memos

[joncmora]

I've tried 2.10 trial and found this bug. It seems that the driver doesn't handle memos correctly if the first character of the memo is byte 0. Borland's MySQL DBX driver handles this correctly.

My field is of type TEXT. My queries look like this:

insert into mytable (myfield) values (:myfield)
update mytable set myfield = :myfield

Delphi interpreted the parameter as ftMemo. In Delphi, my code looks like this:

SQLDataSet1.Params[0].AsMemo := #0#224#7#1#200#42#227#115#92;
SQLDataSet1.ExecSQL;

After execution, looking at the length of the stored value reveals 0 chars:

select length(cast(myfield as char)) from mytable


The memo is a fingerprint feature supplied by a fingerprint scanner.

[Ikar]

Thank you for information.
We reproduced your problem and fixed it. This fix will be included in the next DbxSda build.