MyDac and MySQL 5.0.27 issue ?

[swierzbicki]

Hi,

I'm having an situation since the upgrade of our MySQL server.
We have upgraded from v4.1.21 to v5.0.27

I have a table with a 'VarcharField ' (varchar).

When VarcharField field is Null the code bellow is working :

Code: Select all

if not(MyQuery.FieldByname('VarcharField').Isnull) then
 If MyQuery.FieldByname('VarcharField').AsString  '' then dosomething else exit ;
....

When VarcharField field is '' (empty string) the code bellow is no more working, delphi always retrun the compaison to true. This code worked on the 4.1 mysql server.

Code: Select all

if not(MyQuery.FieldByname('VarcharField').Isnull) then
 If MyQuery.FieldByname('VarcharField').AsString  '' then dosomething else exit ;
....

Is it possible that the MyDAC component don't retreive the string field correctly ?

Thank you for your support

[Antaeus]

We have tested this issue with MySQL Server 5.0.26 but the problem was not found. It is unlikely that the problem is in MyDAC because we thoroughly test this functionality before every build. Moreover, other users never reported us about such problems.
Please send us (evgeniyD*crlab*com) a complete small sample that has different behaviour working with these server versions.