Inserting binary data into BLOB columns

Question

How do I insert binary data into a column of type BLOB of a SQLite database in Laravel?

Limon Monte · Accepted Answer · 2015-04-04 10:29:31Z

2

If column in your table is BLOB type, e.g. you created it in migration like this:

Schema::table('images', function($table) {
    $table->binary('data');
})

Then you should be able to insert binary data by using regular insert() method:

DB::table('images')->insert([
    'data' => $binaryFile   
]);

Or like this:

DB::table('test')->insert([
    'data' => DB::raw("LOAD_FILE('/path/to/file')")
]);

answered Apr 4, 2015 at 10:29

Limon Monte

54.8k49 gold badges191 silver badges222 bronze badges

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

1 Comment

Thank you. It tried several try , but eventually was implemented in x'1234567'. sqlite.1065341.n5.nabble.com/Inserting-BLOB-values-td3611.html