Skip to Content
0

ASE 15.0.3 - MD5 returns different results through jdbc

Jul 19, 2017 at 05:05 PM

31

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers