Re: occasional mcrypt problems

"Steve Yates" <steve@teamITS.com> wrote in message news:20030117193854.47374.qmail@pb1.pair.com... > 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 ~