German country name for UK is longer then 50 characters as defined as max column length

stefangabos / world_countries

Constantly updated lists of world countries and their associated alpha-2, alpha-3 and numeric country codes as defined by the ISO 3166 standard, available in CSV, JSON , PHP, SQL and XML formats, in multiple languages and with national flags included; also available are the ISO 3166-2 codes of provinces/ states associated with the countries

http://stefangabos.github.io/world_countries/

Other

1.35k stars 375 forks source link

German country name for UK is longer then 50 characters as defined as max column length #8

Closed markovanderpuil closed 5 years ago

markovanderpuil commented 5 years ago

(826, 'de', 'Vereinigtes Königreich Großbritannien und Nordirland') is 52 characters and probably longer in UTF-8 multibyte.

Propose to increase name varchar(50) NOT NULL DEFAULT '', to name varchar(60) NOT NULL DEFAULT '',

in world_countries/data/de/countries.sql on line 7

There may be more languages for which this is true....

stefangabos commented 5 years ago

Thanks!