geonames icon indicating copy to clipboard operation
geonames copied to clipboard

use utf8mb4 for names and altnames

Open nitper opened this issue 10 years ago • 1 comments

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 and here. This is a fix that requires mysql >= 5.5

This is the error you get with utf8:

selection_001

nitper avatar Jun 11 '14 18:06 nitper

@nitper sorry for the delay, looks that we need to import illumiante/support in order to make the tests pass. Use the facade Illuminate\Support\Facades\DB should get the tests green.

Do you wanna push it and check?

ipalaus avatar Jul 31 '14 14:07 ipalaus