Author |
Message |
05/04/2011 17:33:52
|
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?
|
|
|
05/04/2011 20:26:55
|
marc
Joined: 08/12/2005 07:39:47
Messages: 4412
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
|
|
|
|
07/04/2011 10:58:39
|
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?
|
|
|
07/04/2011 15:08:58
|
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
|
|
|
|