Subject | Re: [Firebird-Java] Binary conversion to VARCHAR (is it expected)? |
---|---|
Author | Roman Rokytskyy |
Post date | 2011-04-13T18:52:06Z |
> This column is intended to store binary data, and was created this way:Which is correct :)
>
> 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.
> 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