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.
Struggling to load Arabic text into MySql 5.6
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: February 08, 2018
Labels: development, digital
Subscribe to: Posts (Atom)