[Gambas-user] Postgresql 9.x error with Blob field

[Emanuele Sottocorno]

Since version 9.0 of Postgresql server, DB.Postgresql component fails
saving an image file to a blob field type. Maybe due a change in
postgresql internals the escaping sequence produces a bad text. No error
on Insert/Select statement, but when you try to load the image into a
PictureBox you get the error 'Unable to load picture'. PictureDatabase
example can be used to test it.
With dumphex command on retrieved file you can note that is not a valid
image file.
Attached the first line output of hexdump -c of gambas logo and same
image inserted into a blob field.


-------------- next part --------------
A non-text attachment was scrubbed...
Name: blob_field.tar.gz
Type: application/x-compressed-tar
Size: 229 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20130627/7d89c25b/attachment.bin>