Tom is right. See http://www.i18nqa.com for more details

Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: Tom Worster <f...@thefsb.org>
Date: Tue, 01 Feb 2011 11:08:28 
To: <oliv...@umich.edu>; <php-i18n@lists.php.net>
Subject: Re: [PHP-I18N] encoding decoding question from iphone to msql and
 back

Unicode LATIN SMALL LETTER E WITH ACUTE in utf8 is 0xC3 0xA9.

Check the character table at:

   http://en.wikipedia.org/wiki/ISO/IEC_8859-1

to see what 0xC3 0xA9 would decode to if you decoded it to latin1.

So I guess everything is working correctly except for one thing: when you
checked the string value in your database it was displayed as if it were
latin1 instead of utf8.



On 2/1/11 10:48 AM, "olivier destrebecq" <oliv...@umich.edu> wrote:

>I'm creating an iphone app that send data to a web server, then stores
>it into mysql, then spit it out in an xml file and sends it back to
>the iphone. i'm hitting some text conversion issue.
>
>the string from the iphone is encoded following:
>         // Escape even the "reserved" characters for URLs
>        // as defined in http://www.ietf.org/rfc/rfc2396.txt
>        CFStringRef encodedValue =
>CFURLCreateStringByAddingPercentEscapes(kCFAllocatorDefault,
>                  
> value,
>                  
> NULL,
>                  
> (CFStringRef)@";/?:@&=+$,",
>                  
> kCFStringEncodingUTF8);
>
>I as using urldecode on the receiving end to decode the character
>before inserting them in the database, but it does not seem to work
>M&Mé's is turned into M&Mé's in the database.
>What should i be using to decode the URL when receiving it?
>
>thank you
>Olivier
>
>--
>PHP Unicode & I18N Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>



--
PHP Unicode & I18N Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to