Thanks for the help. Unfortunately, it didn't work. My database, table and fields are all UTF-8. The ciphered values import from the dump file into the table correctly. The problem is that I believe they are incorrect in the dump file itself. Meaning, mysqldump did not export them properly and somehow changed the encoding. I don't know if I can do anything to convert the odd ciphers back to what they should look like.
Here's an example of a "good" cipher. It's a value that was created on the server and stored directly into the database table. In other words, it has not been exported/imported: Ôd§5ð£ïäì Here's an example of a "bad" cipher from my backup file (generated by mysqldump): Ó`ª5ñ¦ïìõM As you can see, the format and pattern are totally different. I'm unable to decipher the second example which means a loss of 450+ field values. On Monday, April 9, 2012 10:24:50 AM UTC-7, etipaced wrote: > > I know there have been discussions surrounding the issue of suhosin with > Cake's Security::cipher() method. I am in the process of discontinuing > usage of Cake's ciphering functionality due to this issue. However, I do > have existing data that has been ciphered already. My problem is that the > data has been exported (via mysqldump) and then imported back into the same > database (on the exact same server). What I didn't notice until after the > fact, is that the ciphered data now looks different than it originally did. > As a result, it's essentially corrupted. Is there anything I can do as I no > longer have the originally created ciphered data, but only mysqldumps of it. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php