修改編碼：
（1)先停止服務
（2）修改my.ini文件
（3）重新啟動服務說明：
如果是在修改my.ini之前建的庫和表，那么庫和表的編碼還是原來的Latin1，要么刪了重建，要么使用
alter語句修改編碼。
|
mysql> create database 0728db charset Latin1; Query OK, 1 row affected (0.00 sec) |
|
mysql> use 0728db; Database changed |
|
mysql> alter table student charset utf8; #修改表字符編碼為UTF8 Query OK, 0 rows affected (0.01 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> show create table student\G *************************** 1. row *************************** Table: student Create Table: CREATE TABLE `student` ( `id` int(11) NOT NULL, `name` varchar(20) CHARACTER SET latin1 DEFAULT NULL, #字段仍然是latin1編碼PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 1 row in set (0.00 sec)文章來源地址http://www.zghlxwxcb.cn/news/detail-707422.html mysql> alter table student modify name varchar(20) charset utf8; #修改字段字符編碼為UTF8 Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> show create table student\G *************************** 1. row *************************** Table: student Create Table: CREATE TABLE `student` ( `id` int(11) NOT NULL, `name` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 1 row in set (0.00 sec) |
|
mysql> show create database 0728db;; +--------+-----------------------------------------------------------------+文章來源：http://www.zghlxwxcb.cn/news/detail-707422.html |Database| Create Database?????????????????????????????????????????????????? | +------+-------------------------------------------------------------------+ |0728db| CREATE DATABASE `0728db` /*!40100 DEFAULT CHARACTER SET latin1 */ | +------+-------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> alter database 0728db charset utf8; #修改數據庫的字符編碼為utf8 Query OK, 1 row affected (0.00 sec) |
|
mysql> create table student (id int , name varchar(20)) charset Latin1; Query OK, 0 rows affected (0.02 sec) mysql> show create table student\G *************************** 1. row *************************** Table: student Create Table: CREATE TABLE `student` ( `id` int(11) NOT NULL, `name` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 1 row in set (0.00 sec) |
|
mysql> show create database 0728db; +--------+-----------------------------------------------------------------+ |Database| Create Database?????????????????????????????????????????????????? | +--------+-----------------------------------------------------------------+ | 0728db | CREATE DATABASE `0728db` /*!40100 DEFAULT CHARACTER SET utf8 */ | +--------+-----------------------------------------------------------------+ 1 row in set (0.00 sec) |
到了這里，關于MySQL——修改數據庫和表的字符編碼的文章就介紹完了。如果您還想了解更多內容，請在右上角搜索TOY模板網以前的文章或繼續(xù)瀏覽下面的相關文章，希望大家以后多多支持TOY模板網！
![[1180]clickhouse查看數據庫和表的容量大小](https://imgs.yssmx.com/Uploads/2024/02/451857-1.png)
