RE: [PHP-DB] convert special characters.

> -----Original Message----- > From: Karl DeSaulniers [mailto:karl@designdrumm.com] > Sent: Friday, August 10, 2012 12:08 AM > To: php-db@lists.php.net > Subject: Re: [PHP-DB] 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? Ah - the perils of copying and pasting, and not actually checking... The short answer is - I don't know, probably not. Also, the "$dbcnx" is the database connection you have already set up with mysql_connect(). To be honest, you should probably give this a read: http://www.php.net/manual/en/mysqlinfo.concepts.charset.php If I had the time right now, I would ;-) Toby