convert special characters.

From: Date: Thu, 09 Aug 2012 10:37:16 +0000
Subject: convert special characters.
Groups: php.db 
Request: Send a blank email to php-db+get-48391@lists.php.net to get a copy of this message
Help! How do I get special characters to convert correctly when inserting and reading from my database. For example. é => é ë => ë I keep getting ë and é using htmlentities, htmlspecialchars, etc... Any pointers? Please! Going bald over here. here is my funcitons function stringToMysqlFormat($original_input) {
               //for inserting the data with special characters INTO mysql
               $html_encoded = htmlentities(mysql_real_escape_string($original_input));
               return $html_encoded;
} function mysqlToHTMLFormat($encoded) {
               //for displaying the data FROM mysql
               $html_decoded = html_entity_decode(stripslashes($encoded));
               return $html_decoded;
} TIA, Karl DeSaulniers Design Drumm http://designdrumm.com

« previous php.db (#48391) next »