geoplanet_places_7.4.1.tsv

We would like to import the data file ( geoplanet_places_7.4.1.tsv ) into a database and use it our application. However, since some of the rows in the datafile have place names in special characters as below, it is not helping us and we are kind-of stuck.

28628569 "JP" "佐世保グリーンホテル" JPN POI 28486857

Is it possible to have the geoplanet_places_7.4.1 data file completely in English ? Please advise.

Thanks,
Sekhar.

The GeoPlanet data files use UTF-8 character encoding. The software you use to read these files must support this encoding.

Place names in the places file are in the language local to the country containing the place. You can find place names in other languages in the aliases file. Some places may not have aliases in some languages (such as WOEID 28628569); in such cases you should use the primary place name. You should plan to import place names from both files if you want to support a specific language. The WOEID of a place may be used as a key into both files.

Eddie Babcock
Yahoo! Geo Technologies

which database are you using?

Thanks for your advice Eddie. When you say 'primary place name' , did you mean the one that is present in the places.tsv ( with the UTF-8 character encoding ) ?