Skip to content

Retieve BLOB data from DB for i gets converted  #11

@bvv400

Description

@bvv400

THE BUG
IBM i DB table column as BLOB data which contains the contents of a JPEG file gets converted when using the bwicompanies/db2-driver in an IBM i V7r4 Seidon PHP Laravel 11 app.
The same app on a Linux RHEL 8 with a Oracle DB driver does not convert the JPEG data.

The data in the IBM i DB table BLOB is a copy from the Oracle DB and is binary the same when both columns are compaired.
(See Check with DB viewer )

To Reproduce
Store a JPEG picture in a BLOB field, retieve the data in a Laravel 11 controller field, print Header information en echo the content of the picture to a Browser session .

Expected behavior
BLOB data should not be converted when retieving it with the db2-driver

Screenshots
wrong (IBM i)
image
right (linux)
image

Code
image

Check with DB viewer
IBM i
image
Oracle
image

ODBC settings

IBM i
image
Oracle
image

Additional context
Add any other context about the problem here.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions