Setting the UTF-8 for MySQL Installations on Windows

FlexNet Code Insight 6.13.3

This section explains how to set UTF-8 character encoding for MySQL installations on Windows.

To set the UTF-8 character encoding for MySQL installations on Windows:

1. Navigate to my.ini or my-default.ini file located in your MySQL Server installation directory, such as C:\Program Files\MySQL\MySQL Server 5.7, and edit the following lines:

[mysqld]

default-character-set=utf8

2. To set the storage engine to InnoDB, add the following line to the my.ini file:

default-storage-engine=innodb