> -----Original Message----- > From: Karl DeSaulniers [mailto:karl@xxxxxxxxxxxxxxx] > Sent: Thursday, August 09, 2012 10:19 PM > To: php-db@xxxxxxxxxxxxx > Subject: Re: 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
