Re: getBytes() returning too much data

Conor,

You are running into a bug in the server where it is doing character set
conversion on the bytea data.  There are a number of threads in the
email archives that talk about this bug.  The workaround is to use
'unicode' as the encoding of your database.

thanks,
--Barry


Conor Beverland wrote:
> Hi,
>
> I'm having a problem retreiving images from a postgreSQL database using
> ResultSet.getBytes() The image is stored in the database as a bytea
> type. I'm running java version 1.4.1 and postgreSQL version 7.3.4
>
> When I insert a file it seems to be the correct size inside the database
> (checked using SQL - length(image))
> However when I use getBytes() or even getBinaryStream() to get the data
> back from the database it always returns too much data.
> The returned bytes contain at least some of the correct data (perhaps
> all) with a load of extra bytes throughout the file. The size increase
> is consistent for each file.
>
> Does anyone know what I'm doing wrong and/or how I might go about making
> it work correctly?
>
> Thanks,
> Conor
>
> I've inserted an image like this: -
>
> File file = new File("myimage.gif");
> try {
>    FileInputStream fis = new FileInputStream(file);
>    int length = (int)file.length();
>    byte[] bytes = new byte[length];
>    fis.read(bytes);
>    fis.close();
>    PreparedStatement ps = db.prepareStatement("INSERT INTO images
>       (image) VALUES (?)");
>    ps.setBytes(1, bytes);
> } catch () { }
>
> And I try to get the image back like this: -
>
> try {
>    Statement stmt = db.createStatement();
>    rs = stmt.executeQuery("SELECT image, length(image) FROM images");
>    while (rs.next()) {
>       byte[] imgBytes = rs.getBytes(1);
>    }
> } catch () { }
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>