In the last episode (Sep 09), Andrew Kuebler said:
> I need to store strings encrypted with TripleDES that sometimes
> contain unprintable characters (Hexidecimal values under 20). The
> values do not seem to properly store in CHAR columns and I don't see
> any other column types that might work.
CHAR fields are allowed to strip trailing blanks. Try a BLOB field.
Also make sure you escape your strings with whatever feature your
language makes available. In C, for example, you would use
mysql_real_escape_string(). If your interface supports bind variables,
use them instead.
http://www.mysql.com/doc/en/mysql_real_escape_string.html
--
Dan Nelson
dnelson@stripped
