トップ＞ open source software＞ mysql charset

mysql charset

mysqlの文字コード

memo

SET names utf8;
SET character_set_client = utf8;
SET character_set_results = utf8;
SET character_set_connection = utf8;

create database test2 default character set utf8;

CREATE TABLE test1 (
SEQ int unsigned not null auto_increment primary key,
shop varchar(128) not null
) TYPE=INNODB,DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

related articles