Error with memos
Posted: Wed 19 Jan 2005 03:05
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.
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.