R
R
Roman Kuzmenko2016-05-31 21:38:22
MySQL
Roman Kuzmenko, 2016-05-31 21:38:22

How to insert an empty BLOB in Firebird?

Hello!
Strange situation. Yii2 and Firebird 2.5 tools Doing an
INSERT

$query = new Query();
        $query->createCommand()
        ->insert('TB_TALKS', [
            'id_talks' => $id_talks,
            'id_client' => $id_client,
            'talks_date' => "",
            'id_contacttype' => "",
            'talks_summary' => "",
            'next_talk_date' => "",
            'id_contact' => "",
            'duration' => ""])->execute();

Field 'talks_summary' type BLOB, Subtype Text
If it is present in the INSERT operation, then some kind of cycle is obtained, instead of one record, 4 records are inserted into the table, as soon as I remove 'talks_summary' from the INSERT the query works fine.
What's wrong? Please help. I will be grateful.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question