Re: DBMS_CRYPTO question

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Tue, 20 Jun 2006 20:09:32 +0200
Message-ID: <44983b48$0$11077$9b4e6d93@newsread4.arcor-online.net>

nkunkov_at_escholar.com schrieb:
> Hello,
> I'm using DBMS_CRYPTO.hash (SH1) and DBMS_CRYPTO.encrypt (AES256).
> I'm hashing and encrypting VARCHAR2(12) and NUMBER(32) columns. I'm
> wondering what is a max length of my hash for both datatypes and what
> is a max length of my encrypted string for both datatypes. I'm
> converting the output of each function (raw(2000))to varchar2. I need
> to know the max size of that character string that would be returned.
> Thank you for your help.
> nk
>

sha1 generates always 160 Bit hash (20 Bytes). AES, if i'm not mistaken , produces ciphertext that matches plaintext length ( that may slightly vary due to padding).

Best regards

Maxim Received on Tue Jun 20 2006 - 13:09:32 CDT