On Tue, Jul 13, 2010 at 7:34 AM, Nicholas Hart <nh...@partsauthority.com> wrote: > Hey, > > I'm trying to find an easy way to replace foreign chars in address fields > that are causing problems. Two examples include æ (\xe6) and ð (\xf0) where > the value in parens is the mysql escape value for these chars. There are > many more such characters and it would probably make sense to create a file > or table listing them along with their replacements. Anyone run into this > and if so how did you solve it? > > Note: the reason this causes an error is because I combine several fields > into json object to transfer to another system. Since json does not > recognize these mysql escape chars, it errors out on each one. Another > option would thus be to find a way to make json handle them... however, not > sure if this might cause error on other system after the transfer and json > decoding.
How are you generating your JSON strings? That might be the source of the problem, as json_encode requires UTF8. -- Mitch _______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
