MySQL encoding problem:

In the My.ini file, change to:

[Client]
Default-character-set = UTF8
port=3306

[MySQL]

Default-character-set=utf8

[Mysqld]

# The TCP/IP Port the MySQL Server would listen on
port=3306

# The default character set that would be used if a new schema or table is
# created and no character set is defined
Character-set-server=utf8

In the console:

mysql-uroot-p123456

Use test

View table:

Show create TABLE hostel;

SQL statements:

ALTER TABLE users convert to character set UTF8;

MySQL encoding problem: