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... Quote 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 ? Quote 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... Quote 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... Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.