Step Right Up to the Howard Bros. Circus Model at The Ringling:
The meticulous replica of a traveling circus has been decades in the making.
If you are struggling to load Arabic text or Emojis into your MySql 5.6 table then:
- Ensure your database, table, and column use uft8mb4 character set.
create database XXXX character set 'utf8mb4' collate 'utf8mb4_unicode_ci'; create table ( ... ) ... character set 'utf8mb4' collate 'utf8mb4_unicode_ci';
- Ensure that the data file you are loading is UTF-8 encoded.
- Run the mysql client with the binary character set.
mysql ... --default-character-set=binary ...
- Load the data with the binary character set.
loading load data local infile 'XXXX.DAT' into table XXXX character set binary ( ... );
Posted on February 08, 2018