[TYPO3-mvc] Let Extbase Query check for NULL in database field

David Schreiber flashmasterdash at gmail.com
Tue Jan 19 10:29:50 CET 2010


Hi Masi,

>Certainly. If the table definitions allows it some columns may contain NULL values (see Mysql docs).
>AFAIK 0 and NULL are distinct in all RDBMSs. Only Oracle makes no distinction between '' (empty
>string) and NULL.

Okay. MySql Docs seem to say the same, although I found this
difference only for fields containing strings (difference between
empty string, and null).

So, is there anyway to check for NULL? Because when matching for
column = 0 it also returns my row containing NULL.

Regards,
David Schreiber


More information about the TYPO3-project-typo3v4mvc mailing list