GeoNames Forum

Hello,

I need some help with languages.

I wonder how to import geonames dump into MySQL, so alternames table could have correct information. I've done as it described in FAQ, my table is UTF-8, but I can see difference in geonames service result and my MySQL database query (geonameid 2998286):

Geonames webservice (correct):
87000,87100,87280,Augustoritum,Limages,Limoges,Limogo,Limog·es,Limotges,Limoĝo,Limòtges,Llemotges,Λιμόζ,Лимож,לימוז',لیموژ,लिमोज,リモージュ,里蒙

My MySQL query (not correct):
87000,87100,87280,Augustoritum,Limages,Limoges,Limogo,LimogÂ·es,Limotges,LimoÄo,LimÃ²tges,Llemotges,Î›Î¹Î¼ÏŒÎ¶,Ð›Ð¸Ð¼Ð¾Ð¶,×œ×™×ž×•×–',Ù„ÛŒÙ…ÙˆÚ˜,à¤²à¤¿à¤®à¥‹à¤œ,ãƒªãƒ¢ãƒ¼ã‚¸ãƒ¥,é‡Œè’™

Another question is how can I extract name of the city in some specific language? For example, I need name of geonameid 2998286 in Russian. How MySQL query will look like?

Hi Alexey

It looks like an encoding problem. The GeoNames dump files are encoded in UTF8. You should use the same encoding.

There is also a file alternatenames.txt in the dump directory. It gives you the name of the place with the ISO language code. For Limoges it will be Лимож with the languge code 'ru'.

Cheers

Marc

marc wrote:

Hi Alexey

It looks like an encoding problem. The GeoNames dump files are encoded in UTF8. You should use the same encoding.

There is also a file alternatenames.txt in the dump directory. It gives you the name of the place with the ISO language code. For Limoges it will be Лимож with the languge code 'ru'.

Cheers

Marc

Thanks Marc.

I will try to import alternatenames.txt in UTF8.