Devart Forums

Posted: **Sat 11 Nov 2006 19:57**

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

Posted: **Tue 14 Nov 2006 14:39**

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.

Devart Forums

MyDac and MySQL 5.0.27 issue ?

MyDac and MySQL 5.0.27 issue ?