MySQL Forums
Forum List  »  Newbie

Re: I use SQLyog create a database by chinese
Posted by: Zach Ellis
Date: October 19, 2023 09:37AM

you could try to change these to one of the Chinese equivalents charsets and that charsets collation if changing character_set_filesystem dosent work.

collation_connection utf8mb4_0900_ai_ci
collation_database utf8mb4_0900_ai_ci
collation_server utf8mb4_0900_ai_ci

character_set_client utf8mb4
character_set_connection utf8mb4
character_set_database utf8mb4
character_set_filesystem binary
character_set_results utf8mb4
character_set_server utf8mb4
character_set_system utf8mb3

you might need to set the default value for these in the the my.ini file
under the [mysqld] so when you restart the server it wont revert back to what it was before.
5.1.9 Using System Variables chapter in the manual about system variables and how to configure them

example
[mysqld]
character_set_server=charsets_name from 10.10 Supported Character Sets and Collations
collation_server=collation_name from 10.10 Supported Character Sets and Collations

when you restart the server when you set these and it dosent start check the error log. It most like didn't start because the variable was named wrong or was removed.

also after changing these create a new database and table to see if it works with a new one if the old one didn't change.

regards
Zach Ellis

Options: ReplyQuote


Subject
Written By
Posted
Re: I use SQLyog create a database by chinese
October 19, 2023 09:37AM


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.