Please Help Solution for Encryptiing Data in SQL 6.5 
Author Message
 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



Tue, 09 Dec 2003 04:40:20 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Please help: Basic help on SQL 6.5 need

2. Please help restore database SQL 6.5 to SQL 2000

3. Please help restore database SQL 6.5 to SQL 2000

4. Please help restore database SQL 6.5 to SQL 2000

5. Desperately seeking SQL Query solution, Help Please!!

6. Help moving data from SQL 6.5 to SQL 2000

7. Help Please, SQL 6.5 NT 4.0 SP4 performance issues

8. SQL 6.5 format files - PLEASE HELP

9. Help New VB 5.0 / SQL Server 6.5 User Connect - Please

10. Please Help with Access 97/SQL 6.5 Problem!

11. SQL 6.5 breakdown, please help.

12. SQL 6.5 Breakdown. Please help


 
Powered by phpBB® Forum Software