1劳殖、創(chuàng)建數(shù)據(jù)庫的時候：
CREATE DATABASE `test`
CHARACTER SET 'utf8'
COLLATE 'utf8_general_ci';
2桃犬、建表的時候
CREATE TABLE `database_user` (
`ID` varchar(40) NOT NULL default '',
`UserID` varchar(40) NOT NULL default '',
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
show variables like "%char%";
set names utf8;
2.查看test數(shù)據(jù)庫的編碼格式:
mysql> show create database test;
3.查看yjdb數(shù)據(jù)表的編碼格式:
mysql> show create table yjdb;
4,查看字段編碼：
SHOW FULL COLUMNS FROM tbl_name;
設(shè)置數(shù)據(jù)庫db_name默認為utf8:
ALTER DATABASE `db_name` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
設(shè)置表tb_name默認編碼為utf8:
ALTER TABLE `tb_name` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
把表默認的字符集和所有字符列（CHAR,VARCHAR,TEXT）改為新的字符集：
ALTERTABLElogtestCONVERTTOCHARACTERSETutf8COLLATEutf8_general_ci;
