Subject Re: [Firebird-Java] OCTETS as binary (and another problem with CachedRowSetImpl)
Author Mark Rotteveel
On Thu, 19 Jul 2012 13:45:16 -0000, "Fabiano"
> Hi all!
> It seems Jaybird is treating "CHAR/VARCHAR CHARACTER SET OCTETS"
> internally as Strings. I personally donĀ“t think it is correct, as OCTETS
> are used to store binary data. What do you think about this?
> I tried to look at Jaybird code some months ago to offer a fix, but at
> that time, it seemed to me it would need a bunch of changes to make it
> work.

The way Jaybird handles (VAR)CHAR CHARACTER SET OCTETS is going to change
in Jaybird 2.3 (see section 'Handling (VAR)CHAR CHARACTER SET OCTETS as
(VAR)BINARY type' in the releasenotes), the change was too complex to
consider for Jaybird 2.2.

You could check if providing connection property octetsAsBytes in your
connection string is sufficient to make CachedRowSetImpl use it correctly
as that property will make the ResultSetMetaData report the column as