doctorbill
asked on
MySQL Collation
I am trying to import a .sql into a blank database in PHPMyAdmin
The Collation is utf8_unicode_ci
The database tables in the .sql file are:
ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ;
I get a collation error telling me that the collation format is unrecognised
How do I proceed with this, please?
The Collation is utf8_unicode_ci
The database tables in the .sql file are:
ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
I get a collation error telling me that the collation format is unrecognised
How do I proceed with this, please?
ASKER
version 5.0.2-dev
Any intention to upgrade your MySQL 5.0.x to a higher version? MySQL 5.0.x is pretty obsolete now
ASKER
Trouble is it's on a hosting site - Plesk control panel
ASKER
The PHP version I am importing to is 7.3.1.4
That is where the error is
That is where the error is
ASKER
sql server version 5.5.55
phpMyAdmin 4.9.0.1
phpMyAdmin 4.9.0.1
ASKER
what happens if I just change the collation reference in the .sql file
are you able to create the blank database with collation utf8mb4_unicode_ci instead?
you mean MySQL or SQL Server ver 5.5.55?
sql server version 5.5.55
you mean MySQL or SQL Server ver 5.5.55?
ASKER
Mysql
ASKER
How do I change the database collation
If I select another one in phpmyadmin it keeps reverting back
If I select another one in phpmyadmin it keeps reverting back
ASKER
I change it in the Server connection collation in phpmyadmin
Just keeps reverting back
Just keeps reverting back
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect - now imported
Thanks all
Thanks all
ASKER
Thanks again
You're welcome.
Do you have the collation option utf8mb4_unicode_ci to be selected there?
if not mistaken there was some changes to the default collation in different version of MySQL, which changed from utf8 to utf8mb4