Null to empty string in Yii2

Question

I have a problem that Yii2 model tries to save empty value as null, not as empty string. As far as I have not null mysql column, I am getting mysql error. In Yii 1 there was a config option 'nullConversion' => PDO::NULL_EMPTY_STRING . How can I achieve the same in Yii2? Just want ORM to save empty values as '', not null. Thanks

marche · Accepted Answer · 2015-09-23 17:13:52Z

2

You can try a different approach to solve this, using rules:

public function rules() {
    return [
        ...
        [['field1', 'field2'], 'default', 'value' => ''],
        ...

This way you can have some fields default to empty strings instead of null, without affecting all fields.

answered Sep 23, 2015 at 17:13

marche

1,7561 gold badge14 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Volodymyr Over a year ago

Yes, but doing that website-wide would be a better approach.

marche Over a year ago

That actually depends, specially if you actually need some fields to default to null.

romeo14 · Accepted Answer · 2015-11-05 13:39:32Z

2

In order to automatically convert the mysql NULL to empty strings in Yii2, use this -

'db' => [
    'dsn' => 'mysql:host=127.0.0.1;dbname=database',
    'attributes' => [
        PDO::ATTR_ORACLE_NULLS => PDO::NULL_TO_STRING
    ]
],

answered Nov 5, 2015 at 13:39

romeo14

5385 silver badges13 bronze badges

1 Comment

Gogol Over a year ago

Dunno how it works, but it does...not the accepted one. +1.

Gherman · Accepted Answer · 2015-10-29 08:11:52Z

0

Yii2 doesn't convert null to an empty string by default. If you don't want it to automatically convert a null to an empty string then:

Check your code and make sure that field contains a null before calling the save method.
beforeSave shouldn't replace fields.
PDO::NULL_TO_STRING should not be set.

Also see this issue.

If you want to automatically convert a null to an empty string then set PDO::NULL_TO_STRING in 'db' component.

    'db' => [
        'dsn' => 'mysql:host=127.0.0.1;dbname=database',
        'attributes' => [
            PDO::NULL_TO_STRING => true
        ]
    ],

edited Oct 29, 2015 at 8:11

Gherman

7,55612 gold badges54 silver badges83 bronze badges

answered Sep 23, 2015 at 14:18

Onedev_Link

2,01215 silver badges27 bronze badges

3 Comments

Volodymyr Over a year ago

So, how can I make it to automatically convert null to empty string?

Onedev_Link Over a year ago

You can extends all your ActiveRecord from class where in beforeSave will be replace all null values to empty strings.

Volodymyr Over a year ago

Yes, did that. So pitty no other solutions.

Collectives™ on Stack Overflow

Null to empty string in Yii2

3 Answers 3

2 Comments

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related