NULL to EMPTY_STRING

[imrooster]

when i setup connection option as PDO::ATTR_ORACLE_NULLS =>PDO::NULL_EMPTY_STRING

and run

$db->insert("table", [ "name" => "foo", "email" => "foo@bar.com", "phone" => "" ]);

the phone field still insert as empty string not null , WHY??

[catfan]

If you want to insert null data, try this:

$db->insert("table", [
    "name" => "foo",
    "email" => "foo@bar.com",
    "phone" => $phone === "" ? null : $phone
]); 

[imrooster]

so the PDO::NULL_EMPTY_STRING doesn't work??

[catfan]

Because the empty string "" is still mapped as PDO::PARAM_STR inside https://github.com/catfan/Medoo/blob/master/src/Medoo.php#L744

Of course, you can just create your insert() method to handle those values and then call Medoo's insert().

function myInsert($data) {

    $result = [];

    foreach ($data as $key => $value) {
        $result[$key] = $value === "" ? null : $value
    }

    $database->insert("table", $result);
}