Perfidus Posted March 20, 2009 Share Posted March 20, 2009 After some research I finally found a full world database with countries, regions, cities, etc... Here you have the link for the SQL: http://rapidshare.com/files/119757880/paises.sql.gz (If you make it work is a fantastic tool) The Problem is, I've been trying to import this sql to my server and I can only get a mess of strange symbols, even though I can see all the contents with my notepad and everything looks fine (it is UTF8 encoded) and every country is perfectly readable, but this is how it looks after importing: БританÑкие ВиргинÑкие о-ва Pretty bad, eh? Can somebody tell me what's going on? iconv and tipycal tricks have been already used... Link to comment https://forums.phpfreaks.com/topic/150361-weird-symbols-after-importing-utf8-encoded-sql/ Share on other sites More sharing options...
dgoosens Posted March 20, 2009 Share Posted March 20, 2009 are you sure your database also is in Unicode ? Link to comment https://forums.phpfreaks.com/topic/150361-weird-symbols-after-importing-utf8-encoded-sql/#findComment-789663 Share on other sites More sharing options...
Perfidus Posted March 20, 2009 Author Share Posted March 20, 2009 I don't really know... Is there any software that can read the sql and give me this kind of feedback? I don't know too much about this DDBB cause I found it on the Web but nobody is complaining about it. If somebody can download the file and take a look at it... Link to comment https://forums.phpfreaks.com/topic/150361-weird-symbols-after-importing-utf8-encoded-sql/#findComment-789692 Share on other sites More sharing options...
dgoosens Posted March 24, 2009 Share Posted March 24, 2009 hi Perfidus, I have downloaded the package and had a look at it... in fact the only parts that look corrupted are the russian and chinese. Did you try to make some queries on this database ? Because, I think it might be quite possible that the issue is the fonts that are used by the database software... and not the database itself... Link to comment https://forums.phpfreaks.com/topic/150361-weird-symbols-after-importing-utf8-encoded-sql/#findComment-792430 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.