Devart Forums

I know that MySQL treat NULL and empty strings ('') as being different. Does MyDac do the same? I noticed yesterday that

MyQuery->FieldByName("StringField")->IsNull returned false

yet the BCB IDE inspector displayed the value of

MyQuery->FieldByName("StringField")->AsString as NULL.

[The field in question has a MySQL default value of ''].

Both MySQL and MyDAC treat NULL values and empty strings as different values. If a field contains the NULL value, the IsNull method returns True, but AsString converts NULL values to empty strings.