Subject Re: [firebird-support] I want to store encrypted passwords in a VARCHAR(50) field
Author Michel LE CLEZIO
Hello,
 
Maybe I'm wrong, but the string produced after encryption may contain some char, that could be not supported by the charset you have taken for your database...
Maybe it's not the case but care about this...
 
Best regards,
Mikey
 


________________________________
De : red_october2009 <kevin.wendy.morris@...>
À : firebird-support@yahoogroups.com
Envoyé le : Vendredi 23 novembre 2012 0h12
Objet : [firebird-support] I want to store encrypted passwords in a VARCHAR(50) field


 

I am using Delphi 7 and CryptoPressStream. When encrypted, the encrypted string could include "control" type characters that I'm worried could mimic an "End of Record" character.

Is there any danger that the encrypted password string, when stored in the DB, could corrupt the table or DB? Should I use a different field type than VARCHAR(50) ?

(Not sure if I want to use a BLOB SUB_TYPE 0 field for this... seems overkill)

Thanks in advance for any help you can provide.




[Non-text portions of this message have been removed]