Hi there Max,
I worked on the Google Store Locator with PHP and MySQL quite a lot but I'm
no seasoned programmer at all so no promises made here on finding the
solution, just suggestions and not necessarily in this order:
Making the html pages UFT8.
<meta http-equiv="content-type" content="text/html; charset=utf-8"/>
Tried making the PHP UFT8 with no difference.
I got rid of Question-Mark oddities but making UFT8 what goes back to the
webpage:
$newnode->setAttribute("name", utf8_encode($row['name']))
After adding the uft_encode (that is said to convert only from ISO-Latin) I
tried with the page phpsqlinfo_add.html ang things went well back and forth.
Everything "looked fine" except for the proximity calculation with all the
sinus and cosines where the SELECT * bugs on one field where I can't seem to
get rid of some characters that slipped the non-UFT8 cleanup.
So I made sure MySQL db, tables and fields were UFT8 (whichever variant
serves you best)
Tried Exporting, treating data with OpenOffice, Textwrangler (I'm on MacOS X
client 10.6), changed MAMP for XAMPP, retried reimporting.
I even tried forceUTF8.php form Sebastián Grignoli but did not go very far.
I found informative the long discussion at Stakoverflow dot com
http://stackoverflow.com/questions/910793/php-detect-encoding-and-make-everything-utf-8
As of now, I still have that one field which bugs the SELECT.
Hang in there! You'll get it right soon.
--
You received this message because you are subscribed to the Google Groups
"Google Maps API V2" 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.
