On Aug 9, 2012, at 5:08 PM, Toby Hart Dyke wrote:
-----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
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
