We have progressed a long way and we are testing the encryption
functions and have seen some odd behaviour and wonder if there is a
problem.

We have a query that shows the original text, the encrypted string and
then the decrypted string - it is working fine.

However, there is a certain pattern of results that we do not understand
where we have identical string values in different records (user name
and event log text).

In the case of user name (8 chars), we have records with identical
strings and the encrypted values (32 chars) are totally different each
time.

So question one is if the initial values are the same why are the
encrypted values not the same (we are not using an initialization
vector)

In the case of the log text (20 chars) the first 32 characters of the
encrypted string is always the same while the remaining 32 are always
different.

So question two is why are we seeing this odd behaviour.

We intend using an initialisation vector to stop this happening but
would still like to understand what is going on.
--
Les Desser
(The Reply-to address IS valid)