[Google Maps API v2] Geo lookup XML returns invalid characters

We're using the geo lookup to obtain long/lat for addresses in foreign
countries. When the geo results are returned, some of the addresses
contain special characters which are causing the XML parser inside
Microsoft SQL to error. If the values were wrapped in cdata tags, it
would be fine. Has anyone else run into the same issue? Any idea of
workarounds? If worse comes to worse we could treat the output XML as
a string, replace all of the special characters, and then parse it in
MSSQL, but that seems like such a hack.

--
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 google-maps-api@googlegroups.com.
To unsubscribe from this group, send email to google-maps-api+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/google-maps-api?hl=en.