Re: convert special characters.

On Aug 9, 2012, at 5:08 PM, Toby Hart Dyke wrote:

-----Original Message----- From: Karl DeSaulniers [mailto:karl@designdrumm.com] Sent: Thursday, August 09, 2012 10:19 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] convert special characters. On Aug 9, 2012, at 5:41 AM, Karl DeSaulniers wrote:

On Aug 9, 2012, at 5:37 AM, Karl DeSaulniers wrote:

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

using UTF-8 Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

No one? Not even a link I can go look this up myself with? I have successfuly converted before, but this time the company is in the netherlands and their special characters are doing this. Also, I have the database set to UTF-8, but when I check the charset: $charset = mysql_client_encoding($con); it returns latin1? Can someone tell me what I am doing wrong here? Not looking for someone to do it for me. Just some help figuring out which way to look. Why is htmlentities() converting wrong? Hope someone out there can help.

You probably aren't setting your database connection to UTF-8. Try doing this before you do anything with the database, after you have connected: mysql_query("SET character_set_results=utf8", $dbcnx); mb_language('uni'); mb_internal_encoding('UTF-8'); mysql_query("SET character_set_results=utf8", $dbcnx); Toby

No, I hadn't done that! Ok, this is a good point to start from. Do I set mysql_query("SET character_set_results=utf8", $dbcnx); twice? Thank you guys for your quick responses! Best, Karl DeSaulniers Design Drumm http://designdrumm.com