problem with read blob from postgres db

[zlatko]

HI all !
Hm i'll try explain its strange problem....have Linux Suse , postgresql 7.3.4, db with client_encoding = unicode. Blobs saved in db in field with type bytea. When i try get blob from db i get bad image(hex is not correct, IMHO something that have relation to unicode :o )



*** conect to database simple without setting something conection options

QByteArray pixPhoto = query.value(0).toByteArray();

[wysota]

The problem probably is that your binary data gets converted according to the codec (either by the database or by the driver). Is the data stored correctly? Try dumping it to the console or bypassing the Qt sql driver or even peek at the database through php.

[zlatko]

Its strange problem was cleaning after reinstall Linux...ok thx for your attention :)

[wysota]

You probably had an incorrect codec in the database and the data was getting corrupted, During reinstall probably the correct codec was installed and the problem disappeared.

[zlatko]

Hm maiby you are right.. but before reinstall Linux i tryed reinstall postgres and that had no effect...