I had a MySQL database with names of roads in it. There is this one entry that gives me problems when I query it from the database: Osmeña Avenue. I stored the data to the DB using Java, and then I viewed the data using phpMyadmin then I saw 4f736d65c3b161204176656e7565 instead of Osmeña Avenue. When I query for the names, I placed them inside an XML file, which I use for my application. When I query for Osmeña Avenue, my program freezes. I found out that in the XML file, the ñ is replaced by a �, which causes the freeze. First, why do I saw a bunch of numbers in the phpMyAdmin view for Osmeña Avenue? And what can I do to get the right string with the special characters from the database using PHP? Thanks in advance!
EDIT: the XML file is used to draw routes using OpenLayers.Format.KML;.