samdarkTo get null from database instead of empty strings you need to set up your DB connection as follows:
'db'=>array(
'connectionString' => 'mysql:host=localhost;dbname=test',
'username' => 'root',
'password' => '',
'charset' => 'utf8',
// here it is:
'nullConversion' => PDO::NULL_EMPTY_STRING,
),
User Contributed Notes 2
it actually works in the opposite direction
I tried it with PDO_MYSQL driver and it seems that the conversion occurs on read operations and not on save, which can make a significant difference in some circumstances (e.g. nullable temporal columns, queries using IS NULL).
Thanks
Thanks for correction. Fixed.
Leave a comment
If you have any questions, please ask in the forum instead.
Join the conversation to share a note.