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?

Options: ReplyQuote


Subject
Written By
Posted
unrecognizable characters when upgrade mysql use mysqldump
September 26, 2020 08:24AM


Sorry, only registered users may post in this forum.

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.