ipalaus/geonames — pull request #17 by nitper (2014-06-11 18:50:49+00:00)
Title: use utf8mb4 for names and altnames

The alternate_names data has utf8 characters that are longer than 3 bytes, so we need to change the character encoding and collation to `utf8mb4` - see [here](https://stackoverflow.com/questions/13653712/java-sql-sqlexception-incorrect-string-value-xf0-x9f-x91-xbd-xf0-x9f) and [here](https://dev.mysql.com/doc/refman/5.6/en/charset-unicode-utf8mb4.html). **This is a fix that requires mysql >= 5.5**

This is the error you get with `utf8`:

![selection_001](https://cloud.githubusercontent.com/assets/301091/3249219/9c4a5038-f196-11e3-82f0-4a14d84ed4c0.png)