Re: converting extended chars to plain ascii
| From: | Richard Lynch | Date: | Fri, 20 Jul 2007 22:11:31 +0000 |
| Subject: | Re: converting extended chars to plain ascii | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-259247@lists.php.net to get a copy of this message | ||
You are calling mysql_real_escape_string, right?...
And is the character set of the MySQL server, and of the MySQL client,
set to whatever character set bjorn with the two-dots-o is in?...
I don't claim to understand this stuff, but I know you can't just
magically make a non-ASCII character somehow survive into ASCII
translation without doing something with it...
On Thu, July 19, 2007 1:53 pm, ahlist wrote:
> Hello,
>
> A libarary I'm using (the cybersource api if it helps any) is dying
> when I pass it "extended" chars - such as bjorn (two dots over the o -
> not sure of the actual name of this char -sorry).
>
> For some reason, the newest version of cybersourc's api aborts on this
> input.
>
> Can anyone recommend a quick way to strip/convert those chars out
> before I pass it to cybersources lib?
>
> I store the data as a varchar in mysql and pull it out in a query.
>
> Thanks for ANY advice. I need to get some sort of fix for this asap.
> cybersource are no help.
>
> Thanks.
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
Some people have a "gift" link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?