Character Set Issues in MySQL stored procedures

MySQL StorageIt is a very important task in MySQL database operations and is also applied to everyone's daily work. Parameters cannot be defined during stored procedures.Character SetTherefore, when a stored procedure is called, the global variable character_set_server is read by default, and the value of this global variable is only read when mysqld is started as the default transport character set in the stored procedure. Therefore, if the data table/field uses the system's default character set (such as latin1), it will not be faulty when calling the stored procedure to update some non-English string fields. However, if the character set of the data table/field is not the default Character Set of the system (for example, the default value is latin1 and the data table uses utf8), the problem may occur.

Solution:

In my. cnf (my. ini in windows), add a line:

Default-character-set = utf8

Or

Character-set-server = utf8

Or. It does not work if the SET syntax is used in the mysql command line after mysqld is started.