Thanks for the help :)

On Jan 27, 5:05 am, Thomas Mueller <[email protected]>
wrote:
> 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.

Reply via email to