obtain a md5 hash value for a string

In both Oracle and PostgreSQL I can get an MD5 hash value for any given string.

For example In Oracle 11gR2:

SQL> select rawtohex( DBMS_CRYPTO.Hash (utl_raw.cast_to_raw('xyz'),2) ) as hash_val from dual;

HASH_VAL
--------------------------------
D16FB36F0911F878998C136191AF705E

and in PostgreSQL 9.6:

ft_node=# select md5('xyz') as hash_val;
             hash_val             
----------------------------------
 d16fb36f0911f878998c136191af705e
(1 row)

As you see, apart from the case, the values match.

How can I get similar functionality in SQL Anywhere 17 ?

hash

asked 27 Aug '17, 14:48

bluefrog
183●14●15●21
accept rate: 0%

flat view

One Answer:

active answers oldest answers newest answers popular answers

It's called hash and it works thusly:

SELECT hash ( 'xyz', 'MD5' ) AS hash_val;

hash_val
d16fb36f0911f878998c136191af705e

permanent link

answered 27 Aug '17, 16:00

Breck Carter
32.5k●541●726●1050
accept rate: 20%

...and it also offers much better hash algorithms than MD5, say SHA256...

(27 Aug '17, 16:13) Volker Barth

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

hash ×7

question asked: 27 Aug '17, 14:48

question was seen: 1,905 times

last updated: 27 Aug '17, 16:13

SAP SQL Anywhere

obtain a md5 hash value for a string

Follow this question

Related questions