📄 ctype_ujis.result

📁 这是linux下运行的mysql软件包,可用于linux 下安装 php + mysql + apach 的网络配置
💻 RESULT
📖 第 1 页 / 共 3 页
字号:
上一页 1 23
AAD4AAD5AAD6AAD7AAD8AAD9AADAAADBAADCAADDAADEAADFAAE0AAE1AAE2AAE3AAE4AAE5AAE6AAE7AAE8AAE9AAEAAAEBAAECAAEDAAEEAAEFAAF0AAF1AAF2AAF3AAF4AAF5AAF6AAF7AAF8AAF9AAFAAAFBAAFCAAFDAAFEABA1ABA2ABA3ABA4ABA5ABA6ABA7ABA8ABA9ABAAABABABACABADABAEABAFABB0ABB1ABB2ABB3ABB4ABB5ABB6ABB7ABB8ABB9ABBAABBBABBCABBDABBEABBFABC0ABC1ABC2ABC3ABC4ABC5ABC6ABC7ABC8ABC9ABCAABCBABCCABCDABCEABCFABD0ABD1ABD2ABD3ABD4ABD5ABD6ABD7ABD8ABD9ABDAABDBABDCABDDABDEABDFABE0ABE1ABE2ABE3ABE4ABE5ABE6ABE7ABE8ABE9ABEAABEBABECABEDABEEABEFABF0ABF1ABF2ABF3ABF4ABF5ABF6ABF7ABF8ABF9ABFAABFBABFCABFDABFEACA1ACA2ACA3ACA4ACA5ACA6ACA7ACA8ACA9ACAAACABACACACADACAEACAFACB0ACB1ACB2ACB3ACB4ACB5ACB6ACB7ACB8ACB9ACBAACBBACBCACBDACBEACBFACC0ACC1ACC2ACC3ACC4ACC5ACC6ACC7ACC8ACC9ACCAACCBACCCACCDACCEACCFACD0ACD1ACD2ACD3ACD4ACD5ACD6ACD7ACD8ACD9ACDAACDBACDCACDDACDEACDFACE0ACE1ACE2ACE3ACE4ACE5ACE6ACE7ACE8ACE9ACEAACEBACECACEDACEEACEFACF0ACF1ACF2ACF3ACF4ACF5ACF6ACF7ACF8ACF9ACFAACFBACFCACFDACFEADA1ADA2ADA3ADA4ADA5ADA6ADA7ADA8ADA9ADAAADABADACADADADAEADAFADB0ADB1ADB2ADB3ADB4ADB5ADB6ADB7ADB8ADB9ADBAADBBADBCADBDADBEADBFADC0ADC1ADC2ADC3ADC4ADC5ADC6ADC7ADC8ADC9ADCAADCBADCCADCDADCEADCFADD0ADD1ADD2ADD3ADD4ADD5ADD6ADD7ADD8ADD9ADDAADDBADDCADDDADDEADDFADE0ADE1ADE2ADE3ADE4ADE5ADE6ADE7ADE8ADE9ADEAADEBADECADEDADEEADEFADF0ADF1ADF2ADF3ADF4ADF5ADF6ADF7ADF8ADF9ADFAADFBADFCADFDADFEAEA1AEA2AEA3AEA4AEA5AEA6AEA7AEA8AEA9AEAAAEABAEACAEADAEAEAEAFAEB0AEB1AEB2AEB3AEB4AEB5AEB6AEB7AEB8AEB9AEBAAEBBAEBCAEBDAEBEAEBFAEC0AEC1AEC2AEC3AEC4AEC5AEC6AEC7AEC8AEC9AECAAECBAECCAECDAECEAECFAED0AED1AED2AED3AED4AED5AED6AED7AED8AED9AEDAAEDBAEDCAEDDAEDEAEDFAEE0AEE1AEE2AEE3AEE4AEE5AEE6AEE7AEE8AEE9AEEAAEEBAEECAEEDAEEEAEEFAEF0AEF1AEF2AEF3AEF4AEF5AEF6AEF7AEF8AEF9AEFAAEFBAEFCAEFDAEFEAFA1AFA2AFA3AFA4AFA5AFA6AFA7AFA8AFA9AFAAAFABAFACAFADAFAEAFAFAFB0AFB1AFB2AFB3AFB4AFB5AFB6AFB7AFB8AFB9AFBAAFBBAFBCAFBDAFBEAFBFAFC0AFC1AFC2AFC3AFC4AFC5AFC6AFC7AFC8AFC9AFCAAFCBAFCCAFCDAFCEAFCFAFD0AFD1AFD2AFD3AFD4AFD5AFD6AFD7AFD8AFD9AFDAAFDBAFDCAFDDAFDEAFDFAFE0AFE1AFE2AFE3AFE4AFE5AFE6AFE7AFE8AFE9AFEAAFEBAFECAFEDAFEEAFEFAFF0AFF1AFF2AFF3AFF4AFF5AFF6AFF7AFF8AFF9AFFAAFFBAFFCAFFDAFFECFD4CFD5CFD6CFD7CFD8CFD9CFDACFDBCFDCCFDDCFDECFDFCFE0CFE1CFE2CFE3CFE4CFE5CFE6CFE7CFE8CFE9CFEACFEBCFECCFEDCFEECFEFCFF0CFF1CFF2CFF3CFF4CFF5CFF6CFF7CFF8CFF9CFFACFFBCFFCCFFDCFFEF4A7F4A8F4A9F4AAF4ABF4ACF4ADF4AEF4AFF4B0F4B1F4B2F4B3F4B4F4B5F4B6F4B7F4B8F4B9F4BAF4BBF4BCF4BDF4BEF4BFF4C0F4C1F4C2F4C3F4C4F4C5F4C6F4C7F4C8F4C9F4CAF4CBF4CCF4CDF4CEF4CFF4D0F4D1F4D2F4D3F4D4F4D5F4D6F4D7F4D8F4D9F4DAF4DBF4DCF4DDF4DEF4DFF4E0F4E1F4E2F4E3F4E4F4E5F4E6F4E7F4E8F4E9F4EAF4EBF4ECF4EDF4EEF4EFF4F0F4F1F4F2F4F3F4F4F4F5F4F6F4F7F4F8F4F9F4FAF4FBF4FCF4FDF4FEDROP TABLE t1;SET collation_connection='ujis_japanese_ci';create table t1 select repeat('a',4000) a;delete from t1;insert into t1 values ('a'), ('a '), ('a\t');select collation(a),hex(a) from t1 order by a;collation(a)	hex(a)ujis_japanese_ci	6109ujis_japanese_ci	61ujis_japanese_ci	6120drop table t1;create table t1 engine=innodb select repeat('a',50) as c1;alter table t1 add index(c1(5));insert into t1 values ('abcdefg'),('abcde100'),('abcde110'),('abcde111');select collation(c1) from t1 limit 1;collation(c1)ujis_japanese_ciselect c1 from t1 where c1 like 'abcdef%' order by c1;c1abcdefgselect c1 from t1 where c1 like 'abcde1%' order by c1;c1abcde100abcde110abcde111select c1 from t1 where c1 like 'abcde11%' order by c1;c1abcde110abcde111select c1 from t1 where c1 like 'abcde111%' order by c1;c1abcde111drop table t1;select @@collation_connection;@@collation_connectionujis_japanese_cicreate table t1 ROW_FORMAT=DYNAMIC select repeat('a',50) as c1 ;insert into t1 values('abcdef');insert into t1 values('_bcdef');insert into t1 values('a_cdef');insert into t1 values('ab_def');insert into t1 values('abc_ef');insert into t1 values('abcd_f');insert into t1 values('abcde_');select c1 as c1u from t1 where c1 like 'ab\_def';c1uab_defselect c1 as c2h from t1 where c1 like 'ab#_def' escape '#';c2hab_defdrop table t1;SET collation_connection='ujis_bin';create table t1 select repeat('a',4000) a;delete from t1;insert into t1 values ('a'), ('a '), ('a\t');select collation(a),hex(a) from t1 order by a;collation(a)	hex(a)ujis_bin	6109ujis_bin	61ujis_bin	6120drop table t1;create table t1 engine=innodb select repeat('a',50) as c1;alter table t1 add index(c1(5));insert into t1 values ('abcdefg'),('abcde100'),('abcde110'),('abcde111');select collation(c1) from t1 limit 1;collation(c1)ujis_binselect c1 from t1 where c1 like 'abcdef%' order by c1;c1abcdefgselect c1 from t1 where c1 like 'abcde1%' order by c1;c1abcde100abcde110abcde111select c1 from t1 where c1 like 'abcde11%' order by c1;c1abcde110abcde111select c1 from t1 where c1 like 'abcde111%' order by c1;c1abcde111drop table t1;select @@collation_connection;@@collation_connectionujis_bincreate table t1 ROW_FORMAT=DYNAMIC select repeat('a',50) as c1 ;insert into t1 values('abcdef');insert into t1 values('_bcdef');insert into t1 values('a_cdef');insert into t1 values('ab_def');insert into t1 values('abc_ef');insert into t1 values('abcd_f');insert into t1 values('abcde_');select c1 as c1u from t1 where c1 like 'ab\_def';c1uab_defselect c1 as c2h from t1 where c1 like 'ab#_def' escape '#';c2hab_defdrop table t1;select hex(convert(_ujis 0xA5FE41 using ucs2));hex(convert(_ujis 0xA5FE41 using ucs2))003F0041select hex(convert(_ujis 0x8FABF841 using ucs2));hex(convert(_ujis 0x8FABF841 using ucs2))003F0041DROP TABLE IF EXISTS t1, t2;DROP PROCEDURE IF EXISTS sp1;set names ujis;set character_set_database = ujis;set character_set_server = ujis;CREATE TABLE t1(c1 char(2)) default charset = ujis;CREATE TABLE t2(c2 char(2)) default charset = ujis;INSERT INTO t1 VALUES(_ujis 0xA4A2);CREATE PROCEDURE sp1()BEGINDECLARE a CHAR(2) CHARSET ujis;DECLARE cur1 CURSOR FOR SELECT c1 FROM t1;OPEN cur1;FETCH cur1 INTO a;INSERT INTO t2 VALUES (a);CLOSE cur1;END|CALL sp1();SELECT c1,c2 FROM t1,t2;c1	c2あ	あSELECT hex(convert(_latin1 0xA4A2 using ujis)),hex(c2) FROM t1,t2;hex(convert(_latin1 0xA4A2 using ujis))	hex(c2)8FA2F0A1F1	A4A2DROP PROCEDURE sp1;DROP TABLE t1;DROP TABLE t2;set names default;set character_set_database=default;set character_set_server=default;
上一页 1 23
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -