--source include/have_ujis.inc --source include/have_innodb.inc --disable_warnings drop table if exists `�ԣ�`; drop table if exists `�ԣ�`; drop table if exists `�ԣ�`; drop table if exists `�ԣ�`; drop table if exists `�ԣ�`; drop table if exists `�ԣ�`; drop table if exists `�ԣ�`; drop table if exists `�ԣ�`; drop table if exists `�ԣ�`; --enable_warnings # # Test TRIM() function with Japanese characters ujis encoding # SET NAMES ujis; SET character_set_database = ujis; CREATE TABLE `�ԣ�` (`�ã�` char(12), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = innodb; CREATE TABLE `�ԣ�` (`�ã�` char(12), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = innodb; CREATE TABLE `�ԣ�` (`�ã�` char(12), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = innodb; CREATE TABLE `�ԣ�` (`�ã�` char(12), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = myisam; CREATE TABLE `�ԣ�` (`�ã�` char(12), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = myisam; CREATE TABLE `�ԣ�` (`�ã�` char(12), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = myisam; CREATE TABLE `�ԣ�` (`�ã�` char(12), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = MEMORY; CREATE TABLE `�ԣ�` (`�ã�` char(12), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = MEMORY; CREATE TABLE `�ԣ�` (`�ã�` char(12), INDEX(`�ã�`)) DEFAULT CHARSET = ujis engine = MEMORY; # Nothing to trim INSERT INTO `�ԣ�` VALUES ('����������'); # Test data for TRIM(TRAILING [remstr] FROM str) INSERT INTO `�ԣ�` VALUES ('������������'); INSERT INTO `�ԣ�` VALUES ('��������������'); INSERT INTO `�ԣ�` VALUES ('����������������'); # Test data for TRIM(LEADING [remstr] FROM str) INSERT INTO `�ԣ�` VALUES ('������������'); INSERT INTO `�ԣ�` VALUES ('��������������'); INSERT INTO `�ԣ�` VALUES ('����������������'); # Test data for TRIM(BOTH [remstr] FROM str) INSERT INTO `�ԣ�` VALUES ('����������������������'); # Test data for TRIM without [remstr] (remove spaces) INSERT INTO `�ԣ�` VALUES (' ���������� '); INSERT INTO `�ԣ�` VALUES ('����������'); INSERT INTO `�ԣ�` VALUES ('������������'); INSERT INTO `�ԣ�` VALUES ('��������������'); INSERT INTO `�ԣ�` VALUES ('����������������'); INSERT INTO `�ԣ�` VALUES ('������������'); INSERT INTO `�ԣ�` VALUES ('��������������'); INSERT INTO `�ԣ�` VALUES ('����������������'); INSERT INTO `�ԣ�` VALUES ('����������������������'); INSERT INTO `�ԣ�` VALUES (' ���������� '); INSERT INTO `�ԣ�` VALUES ('���ݏ�ޏ�ߏ��'); INSERT INTO `�ԣ�` VALUES ('���ݏ�ޏ�ߏ���'); INSERT INTO `�ԣ�` VALUES ('���ݏ�ޏ�ߏ������'); INSERT INTO `�ԣ�` VALUES ('���ݏ�ޏ�ߏ���������'); INSERT INTO `�ԣ�` VALUES ('������ݏ�ޏ�ߏ��'); INSERT INTO `�ԣ�` VALUES ('���������ݏ�ޏ�ߏ��'); INSERT INTO `�ԣ�` VALUES ('������������ݏ�ޏ�ߏ��'); INSERT INTO `�ԣ�` VALUES ('������������ݏ�ޏ�ߏ���������'); INSERT INTO `�ԣ�` VALUES (' ���ݏ�ޏ�ߏ�� '); INSERT INTO `�ԣ�` VALUES ('����������'); INSERT INTO `�ԣ�` VALUES ('������������'); INSERT INTO `�ԣ�` VALUES ('��������������'); INSERT INTO `�ԣ�` VALUES ('����������������'); INSERT INTO `�ԣ�` VALUES ('������������'); INSERT INTO `�ԣ�` VALUES ('��������������'); INSERT INTO `�ԣ�` VALUES ('����������������'); INSERT INTO `�ԣ�` VALUES ('����������������������'); INSERT INTO `�ԣ�` VALUES (' ���������� '); INSERT INTO `�ԣ�` VALUES ('����������'); INSERT INTO `�ԣ�` VALUES ('������������'); INSERT INTO `�ԣ�` VALUES ('��������������'); INSERT INTO `�ԣ�` VALUES ('����������������'); INSERT INTO `�ԣ�` VALUES ('������������'); INSERT INTO `�ԣ�` VALUES ('��������������'); INSERT INTO `�ԣ�` VALUES ('����������������'); INSERT INTO `�ԣ�` VALUES ('����������������������'); INSERT INTO `�ԣ�` VALUES (' ���������� '); INSERT INTO `�ԣ�` VALUES ('���ݏ�ޏ�ߏ��'); INSERT INTO `�ԣ�` VALUES ('���ݏ�ޏ�ߏ���'); INSERT INTO `�ԣ�` VALUES ('���ݏ�ޏ�ߏ������'); INSERT INTO `�ԣ�` VALUES ('���ݏ�ޏ�ߏ���������'); INSERT INTO `�ԣ�` VALUES ('������ݏ�ޏ�ߏ��'); INSERT INTO `�ԣ�` VALUES ('���������ݏ�ޏ�ߏ��'); INSERT INTO `�ԣ�` VALUES ('������������ݏ�ޏ�ߏ��'); INSERT INTO `�ԣ�` VALUES ('������������ݏ�ޏ�ߏ���������'); INSERT INTO `�ԣ�` VALUES (' ���ݏ�ޏ�ߏ�� '); INSERT INTO `�ԣ�` VALUES ('����������'); INSERT INTO `�ԣ�` VALUES ('������������'); INSERT INTO `�ԣ�` VALUES ('��������������'); INSERT INTO `�ԣ�` VALUES ('����������������'); INSERT INTO `�ԣ�` VALUES ('������������'); INSERT INTO `�ԣ�` VALUES ('��������������'); INSERT INTO `�ԣ�` VALUES ('����������������'); INSERT INTO `�ԣ�` VALUES ('����������������������'); INSERT INTO `�ԣ�` VALUES (' ���������� '); INSERT INTO `�ԣ�` VALUES ('����������'); INSERT INTO `�ԣ�` VALUES ('������������'); INSERT INTO `�ԣ�` VALUES ('��������������'); INSERT INTO `�ԣ�` VALUES ('����������������'); INSERT INTO `�ԣ�` VALUES ('������������'); INSERT INTO `�ԣ�` VALUES ('��������������'); INSERT INTO `�ԣ�` VALUES ('����������������'); INSERT INTO `�ԣ�` VALUES ('����������������������'); INSERT INTO `�ԣ�` VALUES (' ���������� '); INSERT INTO `�ԣ�` VALUES ('���ݏ�ޏ�ߏ��'); INSERT INTO `�ԣ�` VALUES ('���ݏ�ޏ�ߏ���'); INSERT INTO `�ԣ�` VALUES ('���ݏ�ޏ�ߏ������'); INSERT INTO `�ԣ�` VALUES ('���ݏ�ޏ�ߏ���������'); INSERT INTO `�ԣ�` VALUES ('������ݏ�ޏ�ߏ��'); INSERT INTO `�ԣ�` VALUES ('���������ݏ�ޏ�ߏ��'); INSERT INTO `�ԣ�` VALUES ('������������ݏ�ޏ�ߏ��'); INSERT INTO `�ԣ�` VALUES ('������������ݏ�ޏ�ߏ���������'); INSERT INTO `�ԣ�` VALUES (' ���ݏ�ޏ�ߏ�� '); #InnoDB SELECT `�ã�`,TRIM(TRAILING '��' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(LEADING '��' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(BOTH '��' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(`�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(TRAILING '��' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(LEADING '��' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(BOTH '��' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(`�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(TRAILING '���'FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(LEADING '���' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(BOTH '���' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(`�ã�`) FROM `�ԣ�`; #MyISAM SELECT `�ã�`,TRIM(TRAILING '��' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(LEADING '��' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(BOTH '��' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(`�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(TRAILING '��' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(LEADING '��' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(BOTH '��' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(`�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(TRAILING '���' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(LEADING '���' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(BOTH '���' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(`�ã�`) FROM `�ԣ�`; #MEMORY SELECT `�ã�`,TRIM(TRAILING '��' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(LEADING '��' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(BOTH '��' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(`�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(TRAILING '��' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(LEADING '��' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(BOTH '��' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(`�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(TRAILING '���' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(LEADING '���' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(BOTH '���' FROM `�ã�`) FROM `�ԣ�`; SELECT `�ã�`,TRIM(`�ã�`) FROM `�ԣ�`; DROP TABLE `�ԣ�`; DROP TABLE `�ԣ�`; DROP TABLE `�ԣ�`; DROP TABLE `�ԣ�`; DROP TABLE `�ԣ�`; DROP TABLE `�ԣ�`; DROP TABLE `�ԣ�`; DROP TABLE `�ԣ�`; DROP TABLE `�ԣ�`;
Name | Type | Size | Permission | Actions |
---|---|---|---|---|
disabled.def | File | 404 B | 0644 |
|
jp_alter_sjis.test | File | 10.37 KB | 0644 |
|
jp_alter_ucs2.test | File | 11.33 KB | 0644 |
|
jp_alter_ujis.test | File | 11.28 KB | 0644 |
|
jp_alter_utf8.test | File | 12.21 KB | 0644 |
|
jp_charlength_sjis.test | File | 2.65 KB | 0644 |
|
jp_charlength_ucs2.test | File | 2.76 KB | 0644 |
|
jp_charlength_ujis.test | File | 2.71 KB | 0644 |
|
jp_charlength_utf8.test | File | 2.96 KB | 0644 |
|
jp_charset_sjis.test | File | 4.95 KB | 0644 |
|
jp_charset_ucs2.test | File | 7.27 KB | 0644 |
|
jp_charset_ujis.test | File | 4.97 KB | 0644 |
|
jp_charset_utf8.test | File | 5.23 KB | 0644 |
|
jp_convert_sjis.test | File | 3.89 KB | 0644 |
|
jp_convert_ucs2.test | File | 6.42 KB | 0644 |
|
jp_convert_ujis.test | File | 4.08 KB | 0644 |
|
jp_convert_utf8.test | File | 4.34 KB | 0644 |
|
jp_create_db_sjis.test | File | 597 B | 0644 |
|
jp_create_db_ucs2.test | File | 643 B | 0644 |
|
jp_create_db_ujis.test | File | 610 B | 0644 |
|
jp_create_db_utf8.test | File | 641 B | 0644 |
|
jp_create_tbl_sjis.test | File | 8.77 KB | 0644 |
|
jp_create_tbl_ucs2.test | File | 9.35 KB | 0644 |
|
jp_create_tbl_ujis.test | File | 9.35 KB | 0644 |
|
jp_create_tbl_utf8.test | File | 9.89 KB | 0644 |
|
jp_enum_sjis.test | File | 3.94 KB | 0644 |
|
jp_enum_ucs2.test | File | 3.89 KB | 0644 |
|
jp_enum_ujis.test | File | 3.68 KB | 0644 |
|
jp_enum_utf8.test | File | 3.94 KB | 0644 |
|
jp_insert_sjis.test | File | 11.8 KB | 0644 |
|
jp_insert_ucs2.test | File | 12.06 KB | 0644 |
|
jp_insert_ujis.test | File | 12.06 KB | 0644 |
|
jp_insert_utf8.test | File | 13.32 KB | 0644 |
|
jp_instr_sjis.test | File | 3.89 KB | 0644 |
|
jp_instr_ucs2.test | File | 3.98 KB | 0644 |
|
jp_instr_ujis.test | File | 3.94 KB | 0644 |
|
jp_instr_utf8.test | File | 4.32 KB | 0644 |
|
jp_join_sjis.test | File | 7.98 KB | 0644 |
|
jp_join_ucs2.test | File | 8.01 KB | 0644 |
|
jp_join_ujis.test | File | 7.97 KB | 0644 |
|
jp_join_utf8.test | File | 8.7 KB | 0644 |
|
jp_left_sjis.test | File | 4.49 KB | 0644 |
|
jp_left_ucs2.test | File | 4.6 KB | 0644 |
|
jp_left_ujis.test | File | 4.55 KB | 0644 |
|
jp_left_utf8.test | File | 5.06 KB | 0644 |
|
jp_length_sjis.test | File | 2.6 KB | 0644 |
|
jp_length_ucs2.test | File | 2.71 KB | 0644 |
|
jp_length_ujis.test | File | 2.67 KB | 0644 |
|
jp_length_utf8.test | File | 2.91 KB | 0644 |
|
jp_like_sjis.test | File | 6.31 KB | 0644 |
|
jp_like_ucs2.test | File | 9.45 KB | 0644 |
|
jp_like_ujis.test | File | 6.69 KB | 0644 |
|
jp_like_utf8.test | File | 7.42 KB | 0644 |
|
jp_locate_sjis.test | File | 3.95 KB | 0644 |
|
jp_locate_ucs2.test | File | 4.04 KB | 0644 |
|
jp_locate_ujis.test | File | 3.99 KB | 0644 |
|
jp_locate_utf8.test | File | 4.37 KB | 0644 |
|
jp_lpad_sjis.test | File | 2.64 KB | 0644 |
|
jp_lpad_ucs2.test | File | 2.76 KB | 0644 |
|
jp_lpad_ujis.test | File | 2.71 KB | 0644 |
|
jp_lpad_utf8.test | File | 2.96 KB | 0644 |
|
jp_ltrim_sjis.test | File | 4.89 KB | 0644 |
|
jp_ltrim_ucs2.test | File | 5.11 KB | 0644 |
|
jp_ltrim_ujis.test | File | 5.07 KB | 0644 |
|
jp_ltrim_utf8.test | File | 5.57 KB | 0644 |
|
jp_ps_sjis.test | File | 9.56 KB | 0644 |
|
jp_ps_ujis.test | File | 9.56 KB | 0644 |
|
jp_replace_sjis.test | File | 3.79 KB | 0644 |
|
jp_replace_ucs2.test | File | 3.93 KB | 0644 |
|
jp_replace_ujis.test | File | 3.89 KB | 0644 |
|
jp_replace_utf8.test | File | 4.27 KB | 0644 |
|
jp_reverse_sjis.test | File | 2.17 KB | 0644 |
|
jp_reverse_ucs2.test | File | 2.22 KB | 0644 |
|
jp_reverse_ujis.test | File | 2.18 KB | 0644 |
|
jp_reverse_utf8.test | File | 2.35 KB | 0644 |
|
jp_right_sjis.test | File | 4.54 KB | 0644 |
|
jp_right_ucs2.test | File | 4.65 KB | 0644 |
|
jp_right_ujis.test | File | 4.61 KB | 0644 |
|
jp_right_utf8.test | File | 5.12 KB | 0644 |
|
jp_rpad_sjis.test | File | 2.64 KB | 0644 |
|
jp_rpad_ucs2.test | File | 2.76 KB | 0644 |
|
jp_rpad_ujis.test | File | 2.71 KB | 0644 |
|
jp_rpad_utf8.test | File | 2.96 KB | 0644 |
|
jp_rtrim_sjis.test | File | 4.89 KB | 0644 |
|
jp_rtrim_ucs2.test | File | 5.11 KB | 0644 |
|
jp_rtrim_ujis.test | File | 5.07 KB | 0644 |
|
jp_rtrim_utf8.test | File | 5.57 KB | 0644 |
|
jp_select_sjis.test | File | 2.52 KB | 0644 |
|
jp_select_ucs2.test | File | 4.77 KB | 0644 |
|
jp_select_ujis.test | File | 2.43 KB | 0644 |
|
jp_select_utf8.test | File | 2.51 KB | 0644 |
|
jp_subquery_sjis.test | File | 5.87 KB | 0644 |
|
jp_subquery_ucs2.test | File | 6.19 KB | 0644 |
|
jp_subquery_ujis.test | File | 6.15 KB | 0644 |
|
jp_subquery_utf8.test | File | 6.46 KB | 0644 |
|
jp_substring_sjis.test | File | 15.15 KB | 0644 |
|
jp_substring_ucs2.test | File | 15.49 KB | 0644 |
|
jp_substring_ujis.test | File | 15.22 KB | 0644 |
|
jp_substring_utf8.test | File | 16.89 KB | 0644 |
|
jp_trim_sjis.test | File | 288 B | 0644 |
|
jp_trim_ucs2.test | File | 7.49 KB | 0644 |
|
jp_trim_ujis.test | File | 7.44 KB | 0644 |
|
jp_trim_utf8.test | File | 8.29 KB | 0644 |
|
jp_union_ujis.test | File | 4.8 KB | 0644 |
|
jp_update_sjis.test | File | 2.4 KB | 0644 |
|
jp_update_ucs2.test | File | 2.49 KB | 0644 |
|
jp_update_ujis.test | File | 2.44 KB | 0644 |
|
jp_update_utf8.test | File | 2.66 KB | 0644 |
|
jp_where_sjis.test | File | 3.67 KB | 0644 |
|
jp_where_ucs2.test | File | 5.42 KB | 0644 |
|
jp_where_ujis.test | File | 3.06 KB | 0644 |
|
jp_where_utf8.test | File | 3.31 KB | 0644 |
|