Modify /etc/my.cnf or /etc/mysql/my.cnf file [client] default-character-set = utf8 [mysqld] default-storage-engine = INNODB character-set-server = utf8 collation-server = utf8_general_ci Restart mysql and use the mysql client to check the encoding show variables like '%char%'; Use UTF-8 encoding when creating a new database create database 'test' default character set utf8 collate utf8_general_ci; Create a table and create fields using UTF-8 encoding create table test ( 'id' int(10) unsigned not null auto_increment, 'name' varchar(50) character set utf8 default '', primary key('id') ) default charset=utf8; The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM. You may also be interested in:
|
<<: CentOS 6-7 yum installation method of PHP (recommended)
>>: Summary of methods to clear cache in Linux system
Previously, the images we used were all pulled fr...
I recently wanted to convert a website to https a...
<br />Now let's take a look at how to cl...
Recently, I encountered the need to embed a player...
As a front-end novice, I tinkered with the front-e...
Many websites have a navigation bar fixed at the ...
Table of contents Preface Introduction Live Easy ...
Preface In a relatively complex large system, if ...
MySQL can be connected not only through the netwo...
Table of contents npm download step (1) Import (2...
Apollo open source address: https://github.com/ct...
Recently, I have done a simple study on the data ...
1. Abnormal performance of Docker startup: 1. The...
In this note, we briefly describe What is the B+T...
Preface Vue (pronounced /vjuː/, similar to view) ...