unrecognizable characters when upgrade mysql use mysqldump
Posted by:
link link
Date: September 26, 2020 08:24AM
unrecognizable characters when upgrade mysql use mysqldump
in the same host, we wan to upgrade from mysql 5.6 to mysql 5.7
the step is as belows:
1.
we create new dirctory to store new mysql 5.7 soft and data.
2.
we use mysqldump -db-charater=utf-8 * to export 5.6 data
3.1
in 5.7, create user and database
3.2
we use mysqldump -db-charater=utf-8 to import step 2 data to 5.7
4.we have double check the charter-set varibles in 5.6 and 5.7
they are all same ,is utf-8.
the issue is :
since our application did't change , only db have move from 5.6 to 5.7,
and the application (ie) show unrecognizable characters when display local language
is there any suggestion how to check the issue?
Subject
Written By
Posted
unrecognizable characters when upgrade mysql use mysqldump
September 26, 2020 08:24AM
September 26, 2020 10:22AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.