I found another way to deal with this. And that's to run the encrypted string through base64_encode before inserting into database and running base64_decode when pulling it out of the database. Mark -----Original Message----- From: Mark Steudel [mailto:mark@xxxxxxxxxxxx] Sent: Sunday, February 12, 2006 11:18 AM To: 'Webmaster'; php-general@xxxxxxxxxxxxx Subject: RE: unsupported binary characters in database, Hmmm ... I guess that's an idea. Any other ways of dealing with this? -----Original Message----- From: Webmaster [mailto:webmaster@xxxxxxxxxxx] Sent: Saturday, February 11, 2006 6:06 PM To: Mark Steudel Subject: Re: unsupported binary characters in database, Mark Steudel wrote: > I have the following encryption function: > > > function RC4( $data) { //ecncrypt $data with the key in $keyfile with > an rc4 algorithm > $pwd = implode('', file(/key.php')); > $pwd_length = strlen($pwd); > for ($i = 0; $i < 255; $i++) { > $key[$i] = ord(substr($pwd, ($i % $pwd_length)+1, 1)); > $counter[$i] = $i; > } > for ($i = 0; $i < 255; $i++) { > $x = ($x + $counter[$i] + $key[$i]) % 256; > $temp_swap = $counter[$i]; > $counter[$i] = $counter[$x]; > $counter[$x] = $temp_swap; > > } > for ($i = 0; $i < strlen($data); $i++) { > $a = ($a + 1) % 256; > $j = ($j + $counter[$a]) % 256; > $temp = $counter[$a]; > $counter[$a] = $counter[$j]; > $counter[$j] = $temp; > $k = $counter[(($counter[$a] + $counter[$j]) % 256)]; > $Zcipher = ord(substr($data, $i, 1)) ^ $k; > $Zcrypt .= chr($Zcipher); > } > return $Zcrypt; > } > source: zend code gallery > > When I encrypt a string that ends in e it shows up as a space in the > database, when I pull it back out of the database, the string is > missing the e. I tried converting the field in the database to a blob > and that didn't work either. My next idea is to add a bin2hex and then > a hex2bin: > > function hex2bin($hexdata) { > $bindata=""; > > for ($i=0;$i<strlen($hexdata);$i+=2) { > $bindata.=chr(hexdec(substr($hexdata,$i,2))); > } > > return $bindata; > } > source: phil at internetprojectmanagers dot com > > I was hoping to get some feedback if this is a good way to go about this. > > Thanks, Mark > > Just add a different letter to the end of the string. So long as it isn't "e" it should be ok yeah? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
