bytea problem

Hello, this is my problem :
I use java + postgres and I want to store image files into a table

my table : (id int,  image bytea)

the code :
                byte bytes[] = new byte[(int)file.length()];

                sqlq ="UPDATE table set image= ? where id=?";
                ps = .....prepareStatement(sqlq);
                ps.setBytes(2,bytes);
                ps.setString(2,id);

put the file into my table, stream of 41054 bytes, OK.

but when I retrieve it from the database resultSet.getBytes("image") gives
an array of 82108 bytes!!
worst of all those bytes I get have no sense at all, like 00 00  00 or 11
11....

thanks for the help!




--
View this message in context: http://postgresql.1045698.n5.nabble.com/bytea-problem-tp5014176p5014176.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.