I have a Java byte field that I'm trying to store
in the database. It has a value of (byte)'0' which is a binary
48.
When I use preparedStatement.setByte() with that
value, to store in a Postgresql CHAR field, it only stores a '4'. It's as
if the binary 48 were being converted to a String and then the first byte from
the string was stored in the database. I'm using 7.1.1beta4.
Does this make any sense? Am I using the
wrong SQL type or the wrong JDBC PreparedStatement set call?
Thanks,
David
|
- Re: [JDBC] SQL CHAR type using setByte() David Wall
- Re: [JDBC] SQL CHAR type using setByte() David Wall