mysql - WordPress negates DB_COLLATE in wp-config -

i'm having trouble installing wordpress on localhost development area. working fine, when want move site online environment problems showing db collation.

i read , seems wordpress created tables on localhost using utf8mb4_unicode_ci charset/collation. although online environment has higher version of mysql running, won't import tables when moving.

i decided force wordpress use older db collation on localhost. changed wp-config this, before running setup:

/** database charset use in creating database tables. */ define('db_charset', 'utf8');  /** database collate type. don't change if in doubt. */ define('db_collate', 'utf8_general_ci'); 

i saved , ran setup. quick check in database resulted in tables still in utf8mb4_unicode_ci collation!

how force wordpress use utf8_general_ci collation?

before installing, comment line in wp-config-sample.php

// define ('db_charset', 'utf8'); // define ('db_collate', ''); 

create database manually utf8_general_ci , install wordpress.

the tables installed default collate database.