Hi, See also my response to "DECRYPT requiring UTF8TOSTRING and TRIM functions"
> You are using STRINGTOUTF8(?) ... on a byte[] (which is not a string) Yes, use "?" instead of "STRINGTOUTF8(?)", or use setString. > return rs.getBytes(0); //What should it return ? This will throw an exception, because the first column is column 1. You need to use return rs.getBytes(1); > the column name There is no (regular) column name. > - You are using CALL ... so should be using a CallableStatement rather than a PreparedStatement ? No, PreparedStatement is fine. CallableStatement should also work I believe (not sure). Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
