"Steve Yates" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> After much testing, I think I may have it. It appears that MySQL is
> dropping a trailing space from the value being inserted into the database!
> For example if the encrypted string is " (.A®¢m¸"¼'À " MySQL stores the
> value without the trailing space (and it is a space). Why is that?
As with many "bugs" it's because I told it to! To my surprise, MySQL
varchar fields have their trailing spaces removed on insertion. Tinyblob or
Tinytext fields do not, so one needs to use those (or their larger brethren)
when saving encrypted or binary data to MySQL. Thanks to those who tried to
help!
- Steve Yates
- Computers make very fast, very accurate mistakes.
~ Taglines by Taglinator - www.srtware.com ~
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
