Devart Forums

hello,

mydac latest version
mysql 4.1.18nt

MyConnection charset utf8
UseUnicode := true

Table in DB is utf8 as well as all fields.

this query:

INSERT INTO table
SET value1 = :value1, value2 = :value2

will be executed fine if I pass data to all values
but if we say

Query.ParamByName('value2').AsString := Edit2.Text

and Edit2.Text is empty (without data)
the Query.Execute produces AV.

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

is this fixed with the new .13 version?

Yes, we have applied this fix to MyDAC 4.30.0.13.