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

On Tue, 20 Mar 2007 17:14:06 -0800, Gleep <Gleep@Gleep.com> wrote:

>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


looks like can't post attachments to this group sorry 'bout that

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

[Reply to this message]