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.
blob_field.tar.gz
Description: application/compressed-tar
------------------------------------------------------------------------------ This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev
_______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
