


The current encoding of MYSQL data is like this. Why is it still garbled when inserting Chinese characters?
Aug 04, 2016 am 09:19 AM
Do I need to change the rest of the database and server? I use wamp and I don’t know how to change it. After setting it up like this and restarting, it looks like in the picture
<code>SET character_set_database = utf8; SET character_set_server = utf8; </code>
I have set three
[client] [mysql] [mysqld] in my.ini. These three settings have become utf8 and it doesn’t work either
Reply content:
Do I need to change the rest of the database and server? I use wamp and I don’t know how to change it. After setting it up like this and restarting, it looks like in the picture
<code>SET character_set_database = utf8; SET character_set_server = utf8; </code>
I have set three
[client] [mysql] [mysqld] in my.ini. These three settings have become utf8 and it doesn’t work either
<code>+--------------------------+-----------------------------------------------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8</code>
Is the question inserted through the web page or the terminal?
There is also the encoding of the table. The key lies in the encoding of the table
<code>create table employee ( //.............. ) DEFAULT CHARSET=utf8;</code>
Write the table creation statement like this, and set the encoding of the table to utf-8, which may solve the problem.

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian

How to fix mysql_native_password not loaded errors on MySQL 8.4
