Encrypted fields showing up as empty
To explain my situation first...
I have a table with some empty fields and some numbers I wish to encrypt.
I perform a select statement to check how many fields are not empty (I get 56), e.g
"SELECT number from customer WHERE NOT number = '' ";
I then encode this using AES_ENCRYPT(number,keystr)
Then try the count query again as written above but this time I have fewer entries (I get 3) that are not empty.
Any ideas why this may be?
Subject
Views
Written By
Posted
Encrypted fields showing up as empty
3224
September 09, 2005 03:11AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.