From: Dan Nelson
Date: September 10 2003 3:01am
Subject: Re: Storing Unprintable Characters
List-Archive: http://lists.mysql.com/mysql/149384
Message-Id: <20030910030128.GB48339@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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