List of countries, cities, languages

home
database
view story

39 Kicks

List of countries, cities, languages(amrelgarhytech.blogspot.com)

submitted by amrelgarhy(825) 3 years, 8 months ago

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: 639
Tweet

tags: Database another

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:

aslan7(0) -

_ama(5) -

garevalo(0) -

vForkOr(10)

More who kicked this story...

Comments:

posted by senfo(881) 3 years, 8 months ago 0

Any idea how often these are updated?

posted by iobe(0) 3 years, 8 months ago 0

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 DamienG(1405) 3 years, 8 months ago 0

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 Jemm(9604) 3 years, 8 months ago 0

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 amrelgarhy(825) 3 years, 8 months ago 0

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 Jemm(9604) 3 years, 8 months ago 0

@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 atifaziz(1000) 3 years, 8 months ago 0

> 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

Most Active Users

What's this?