Ok, changed the table to UTF-8 - doesn't seem to of been to any detriment.
Have now stumbled across the reason for presumably a lot of other places not working - it is pulling up american towns...! Can it be set to only look at the UK? So maybe just append ", UK" to every search query? Cheers, Tony On Oct 8, 3:04 pm, "[email protected]" <[email protected]> wrote: > I've been through and there were a couple of β characters in there, > looking for more issues now. > > There are literally hundreds of &'s in there thanks to Holland & > Barrett, but these seem to come up ok? > > Is there an easy way to search/purge a database of non UTF-8 text? > > Cheers, > > Tony > > On Oct 8, 2:49 pm, Mike Williams <[email protected]> wrote: > > > Try looking at what you get if you point your browser directly at that > > searchUrl: > > >http://www.udoschoice.co.uk/phpsqlsearch_genxml.php?lat=50.3703805&ln... > > .142653&radius=30 > > > You get an illegal character on line 47 of your PHP code when attempting > > to process some location that's between 4 and 5 miles from the centre of > > Plymouth. > > > -- > > Mike Williamshttp://econym.org.uk/gmap --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Maps API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/google-maps-api?hl=en -~----------~----~----~----~------~----~------~--~---
