Please Help Solution for Encryptiing Data in SQL 6.5
If the data is always 24 characters then just create a char column 24 characters wide. Whatever the non-printable/readable characters are, as long as they exist in the collation that SQL 6.5 is configured for they should be a problem.
Have you ensured that the product that is extracting the data from the table is trying to decrypt only 24 characters and not including some spaces in there?
Quote:
> We are working with a Java application that is encrypting
> data via DES3/MD5. We are then inserting this data into a
> varchar(255) field. The data is always 24 characters in
> length, with many non-printable/readable characters. When
> we read/select the information back out and decrypt it
> with the same key, we are finding that roughly 17 per 5000
> are not decrypting properly. They are either not
> completely decrypting or only part of the data is
> encrypting.
> Does anyone have a solution?
> Thanks
> Steve
