8 Replies Latest reply on Jun 15, 2007 8:09 AM by insuractive

    Encrypt / Decrypt Deleting Leading Zero

      As always when I'm totally stumped I fall back on the greatest support network ever. I'm having a problem where the leading zero from a string of submitted numbers is being lost, somewhere, in either the encrypt or decrypt (I think). Here's the sit:

      1. Users input 10 digit numeric information
      2. I use Not IsNumeric to verify that the information input are actually numbers
      3. The submitted numbers are encrypted using encrypt with AES / HEX
      4. Inserted into the MySQL DB using cfsqltype="cf_sql_varchar"
      5. DB field is set to VARCHAR

      Any thoughts on why either the system or DB might be deleting the leading zero? I'm wondering if I need to change the field type to BLOB or TEXT.