AES Encryption -- Data type?



Hi, quick question for those of you who might have done this --

We're encrypting credit cards using AES encryption and trying to put
the value into a character field within SQL Server. This works
absolutely fine unless there the encryption routine puts a NULL
character anyplace within the resulting string; then it just chokes.

Anybody done this before? Is it a limitation of the column data type?
A limitation in the JDBC driver?

Thanks in advance

.



Relevant Pages

  • Re: System.Security.Cryptography
    ... then only problem with this encryption is the 58 chars ... limitation... ... Prev by Date: ...
    (microsoft.public.dotnet.general)
  • Re: Issue using encryption in Debug/Release mode ??
    ... > I would like to ask you something regarding AES encryption, ... my library using AES works fine on our machines. ... we have encrypted files with the DEBUG version of KEM.dll ...
    (sci.crypt)
  • Re: ECB-Counter AES mode
    ... sequential counter value over the plain text block with XOR prior to ... AES encryption and removing the counter value after AES decryption? ...
    (sci.crypt)
  • Re: ECB-Counter AES mode
    ... counter value over the plain text block with XOR prior to AES encryption and ... well studied encryption modes have been rejected in favour of a home grown mode. ... The IEEE SISWG has been working on exactly this sort of problem for disc sector encryption so it would be worth looking at the XTS and EME-2 modes that they have developed. ...
    (sci.crypt)
  • Re: ECB-Counter AES mode
    ... counter value over the plain text block with XOR prior to AES encryption and ... removing the counter value after AES decryption? ... well studied encryption modes have been rejected in favour of a home grown mode. ...
    (sci.crypt)