GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Strange characters inside the DB  XML
Forum Index -> Discussion of GeoNames Toponyms
Author Message
Elsammak



Joined: 05/04/2011 17:30:34
Messages: 12
Offline

I downloaded the DB AllCountries.Zip & when I decompress it & open AllCountries.txt, I found there are some strange characters although the encoding is UTF-8 as shown in readme.txt.
ex. (t Julià de Lòria Sant Julia de Loria San Julia,San Julià,San-Dzhulija-de-Lorija,San-Khulija-de-Lorija,Sant Julia de Loria,Sant Julià de Lòria,sheng hu li ya-de luo li ya,Сан-Джулия-де-Лория,Сан-Хулия-де-Лория,サン・ジュリア・デ・ロリア教区,圣胡利娅-德洛里亚,圣胡利娅-德洛里亚 42.46372 1.49129 P PPLA AD 06 8022 1045 Europe/Andorra 2008-10-15)

So, how to retrieve the data in readable way?
marc



Joined: 08/12/2005 07:39:47
Messages: 3993
Offline

the program you are using to view the data needs to be able to display utf8 and it needs to be told that it is utf8. It is not a geonames related issue.

Marc

[WWW]
Elsammak



Joined: 05/04/2011 17:30:34
Messages: 12
Offline

I'm now trying to convert it to mysql uning phpMyAdmin.
I tried utf8_general_ci & utf8_Unicode_ci..but I got the same issue.
what kind of encoding I've to use?
Elsammak



Joined: 05/04/2011 17:30:34
Messages: 12
Offline

ok, I found the reply, just write "set names 'utf-8' be4 importing ur DB
 
Forum Index -> Discussion of GeoNames Toponyms
Go to:   
Powered by JForum 2.1.5 © JForum Team