mysql校对集的用法小示例一

mysql校对集的用法小示例一：

1、

create database demo;

use demo;

create table emp(id_emp int unsigned auto_increment primary key,a_emp varchar(20) character set 'utf8' collate 'utf8_general_ci',b_emp varchar(20) character set 'utf8' collate 'utf8_general_ci');

insert into emp(a_emp,b_emp) values('a','A');

select a_emp=b_emp from emp;    /*    1     */

2、

create database demo;

use demo;

create table emp(id_emp int unsigned auto_increment primary key,a_emp varchar(20) character set 'utf8' collate 'utf8_bin',b_emp varchar(20) character set 'utf8' collate 'utf8_bin');

insert into emp(a_emp,b_emp) values('a','A');

select a_emp=b_emp from emp;    /*    0     */