aes_encrypt aes_decrypt problem

[schizoman]

This is really weird. I'm using PHP 4 with mySQL. I'm using aes_encrypt and _decrypt to store customer information as securely as possible. The problem crops up when I go to store (or retrieve -- I'm not sure which) the state that the customer lives in.

AL works for Alabama
GA works for Georgia
fl works for Florida
FL returns an empty string.

Does anyone have any ideas on what's happening here? Thanks.

 

[TonyGroves]

Presumably you're looking at a case-sensitivity issue here. When you encrypt "fl" you would get an entirely different result than when you encrypt "FL".

 

[schizoman]

Well, yeah, that's true. But why would "FL" (encrypted then decrypted) not work, while others (case sensitive -- upper case) do? Thanks.

 

[TonyGroves]

Maybe it was originally stored as "fl" when the others were stored in uppercase.