1、安裝時(shí)選擇Locale
（1）安裝時(shí)選擇Locale為Default locale产阱，Locale由操作系統(tǒng)決定
Default locale
（2）Windows10簡(jiǎn)體中文安裝后，為Chinese(Simplified)_China.936
數(shù)據(jù)庫(kù)屬性
備注：安裝時(shí)locale可以選擇Chinese(Simplified),China
可選項(xiàng)中包含簡(jiǎn)體中文
2块仆、Locale為C排序示例
SQL語句
create table x (n varchar(4));
insert into x values('王');
insert into x values('李');
insert into x values('里');
insert into x values('張');
insert into x values('莉');
insert into x values('裏');
insert into x values('劉');
insert into x values('張');
insert into x values('a');
insert into x values('b');
insert into x values('A');
insert into x values('B');
select * from x order by n;
執(zhí)行結(jié)果
C排序結(jié)果
3构蹬、Locale為Chinese(Simplified)_China.936排序示例
Chinese(Simplified)_China.936排序結(jié)果
轉(zhuǎn)載請(qǐng)注明：作者gisxiaowei王暗，首發(fā)簡(jiǎn)書 jianshu.com
