Subject Re: [Firebird-Java] Binary conversion to VARCHAR (is it expected)?
Author Roman Rokytskyy
> This column is intended to store binary data, and was created this way:
>
> create table t (
> column CHAR(16) CHARACTER SET OCTETS
> COLLATE OCTETS);
>
> Now i´m selecting from this column, and Jaybird is considering it is a VARCHAR.

Which is correct :)

> The problem is that i use a CachedRowSet implementation to store the ResultSet in memory and close the connection, and the CachedRowSet implementation thinks it is a VARCHAR column when caching it, and it loses information and gives an exception when i call this column from the CachedRowSet.

How do you try to get the column data (rs.getString() or rs.getBytes())
and what exception do you get?

> Is this expected or can be considered a bug or a candidate for improvement?

At the moment, I'd say, it is correct behaviour, but please post the
exception you get.

Roman