Create a database with charset utf-8
CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_general_ci; or CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
Tag: utf8
Mysql dump encoding errors
If you get some errors like ’ instead of apostrophe try the following $contents = mb_convert_encoding( file_get_contents( ‘FILEPATH_OF_PROBLEMATIC_FILE’ ), “HTML-ENTITIES”, “UTF-8” […]