Posted by Gleep on 03/21/07 01:14

On 20 Mar 2007 11:01:28 -0700, matthud@gmail.com wrote:

>The following string:
>"US generals ‘will quit’ if Bush orders Iran attack"
>
>is being stored in my table as:
>
>"US generals ‘will quit’ if Bush orders Iran attack"
>
>The only PHP function I'm applying to the string is
>mysql_real_escape_string, and that doesn't appear to be the root of
>the problem. I'm using utf8_general_ci as my collation.
>
>Forgive my ignorance.



user this function on all incoming variables
will clean out the junk characters and replace with ascii

<?php
function asciify($str)
{
$unicode_array = array("&#8211;" => "-",
"&#8212;" => "-",
"–" => "-",
"&#8216;" => "'",
"’" => "'",
"&#8217;" => "'",
"‘" => "'",
"&#8230;" => "...",
"…" => "...",
"“" => "\"",
"&#8220;" => "\"",
"”" => "\"",
"&#8221;" => "\"");
$str = strtr($str, $unicode_array);
return strtr($str, "ŠŒŽšœžŸ¥µÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝßàáâãäåæçèéêëìíîïðñòóôõöøùúûüýÿ",
"SOZsozYYuAAAAAAACEEEEIIIIDNOOOOOOUUUUYsaaaaaaaceeeeiiiionoooooouuuuyy");
}
?>


darn look like my new reader will not post the correct charas
so I will also attach the file

• Next in forum: Re: Strange characters in MYSQL? - ascii characters only.php (0/1)
• Prev in forum: Re: Keep-Alive and Content-Length problem
• Thread view: Re: Strange characters in MYSQL? - ascii characters only.php (0/1)

[Reply to this message]