List of countries, cities, languages

Why not join our community?, there are 3 users online

home
database
view story

DotNetKick.com is an open-source project. Please report any bugs and let us know your great suggestions. Currently running svn revision 620 (rss)

Kick Spy!, Kick Zeitgeist and Kick Widgets

38
kicks

kick it

List of countries, cities, languages

published 2 months, 20 days ago, submitted by amrelgarhy 2 months, 20 days ago

amrelgarhytech.blogspot.com — You will find in the following links list of countries, cities, and their languages in CSV format, you can import into any database:

7 comments | category:

Database | Views: 489 | Get KickIt image code

tags: Database | tag it

Everyones tags:

Your tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

amrelgarhy -

StefanPienaar -

mdopp -

mosessaur - stribny - Zero3 -

Jemm -

janko - bags - AdamSmith - redcap - Reman - ingaar -

bradygaster - spootwo -

korayem - mghaoui - marshall - BlackWasp - ourcurrentfuture - ercu -

drugarce - up2jj - johnman - senfo - khushal999p -

ferrymulyono - cdbh - bladefist - asteroid -

adminjew - phatboyslim - Zteff - vForkOr - yuyutoo12 - bornykd - garevalo - _ama

Comments:

Any idea how often these are updated?

posted by senfo 2 months, 19 days ago

I don't get the right characters for anything but a-z.

Used this to import the data BTW:

BULK INSERT City
FROM 'C:\City.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)

posted by iobe 2 months, 19 days ago

The country list there is out of date - it doesn't even include the Channel Islands that were added in 2006.

Just go to the master source for this information and bypass all the adverts on this site - http://www.iso.org/iso/country_codes/iso_3166_code_lists.htm

[)amien

posted by

DamienG 2 months, 19 days ago

Also, the scripts on pages have Arabic_CI_AS as collation, which isn't necessarily what you want.

Just remove COLLATE Arabic_CI_AS -parts to get your default collation.

posted by

Jemm 2 months, 19 days ago

For data update and collation:
All of these data taken from this db: http://downloads.mysql.com/docs/world.sql.zip and i just formatted for SQL server, so i don't know how to make these date updated, and if you can't see some characters just change your DB collation, or open the mysql original one.
I just tried to help nothing more.:)

Thanks,

posted by amrelgarhy 2 months, 19 days ago

@amrelgarghy:
Yeah, it was great help - I just gave a tip ;)

Collations are awkard when a wrong collation is used. Changing collation requires reinserting of data so that the sort order etc will be right.

posted by

Jemm 2 months, 19 days ago

> Any idea how often these are updated?

@senfo: This is just sample data from MySQL dev docs and to play around with in MySQL. See “Setting Up the world Database” over at:

http://dev.mysql.com/doc/world-setup/en/world-setup.html

I wouldn't count on it being kept up to date. It's probably a snapshot from some point in time. The doc does, however, quote the source (“The sample data used in the world database is Copyright Statistics Finland”) so you may just want to go directly there for the most up to date versions:

http://www.stat.fi/worldinfigures

posted by

atifaziz 2 months, 4 days ago