ASE 15.0.3 - MD5 returns different results through jdbc

[Former Member]

Hi

I am trying to execute the below query using the hashbyes function and getting different results through jdbc compared with isql.

SELECT col1_pk, hashbytes ('md5',col1_pk,col2) FROM tab1

isql - results for hash (0x40cdd3b0958ab249d4c6aa7b7501c389)

jtds-1.3.1.jar - results for hash (@ÍÓ°•Š²IÔƪ{u
É)

jconn4.jar - error (JZ0TE: Attempted conversion between an illegal pair of types. Valid database datatypes are: '(text, Clob) (unitext, Clob) (unitext, NClob) (unitext, Clob) (image, Blob)')

Please suggest how I can get the same results as that in isql?

Thanks