Demos · Guide · Class Reference · Wiki · Extensions · Forum · Live Chat · Login

Getting nulls from database instead of empty strings

To 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,
),

Total 2 comments

#4023

samdark at 2011/05/29 02:32pm

Thanks

Thanks for correction. Fixed.

#4020

phtamas at 2011/05/29 10:07am

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).

Please login to leave your comment.

Write new article

Written by: samdark
Category: Tips
Votes: +11
Viewed: 4,125 times
Created on: May 7, 2011
Last updated: May 29, 2011
Tags: database, null

Yii Supporters

Clevertech supports Yii. Clevertech builds custom solutions to cut overhead, create relevant management reporting and deliver profits.
The Ext4Yii Framework is a professional PHP Yii extension which provides server-side ExtJS functionality.

Getting nulls from database instead of empty strings

Total 2 comments

Leave a comment

Yii Supporters