Re: convert special characters.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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




[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux