--source include/have_sjis.inc --source include/have_innodb.inc --character_set sjis --disable_warnings drop table if exists `�s�P`; drop table if exists `�s�Q`; drop table if exists `�s�R`; drop table if exists `�s�S`; drop table if exists `�s�T`; drop table if exists `�s�U`; drop table if exists `�s�V`; drop table if exists `�s�W`; drop table if exists `�s�X`; --enable_warnings # # Test LTRIM() function with Japanese characters in sjis encoding # SET NAMES sjis; SET character_set_database = sjis; CREATE TABLE `�s�P` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `�s�Q` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `�s�R` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `�s�S` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `�s�T` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `�s�U` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `�s�V` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY; CREATE TABLE `�s�W` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY; CREATE TABLE `�s�X` (`�b�P` char(8), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY; INSERT INTO `�s�P` VALUES ('�����'); INSERT INTO `�s�P` VALUES (' �����'); INSERT INTO `�s�P` VALUES (' �����'); INSERT INTO `�s�P` VALUES (' �����'); # Double byte spaces are not supposed to be trimed INSERT INTO `�s�P` VALUES ('�@�����'); INSERT INTO `�s�P` VALUES ('�@�@�����'); INSERT INTO `�s�P` VALUES ('�@�@�@�����'); INSERT INTO `�s�Q` VALUES ('����������'); INSERT INTO `�s�Q` VALUES (' ����������'); INSERT INTO `�s�Q` VALUES (' ����������'); INSERT INTO `�s�Q` VALUES (' ����������'); # Double byte spaces are not supposed to be trimed INSERT INTO `�s�Q` VALUES ('�@����������'); INSERT INTO `�s�Q` VALUES ('�@�@����������'); INSERT INTO `�s�Q` VALUES ('�@�@�@����������'); INSERT INTO `�s�R` VALUES ('�\�\�\�\�\'); INSERT INTO `�s�R` VALUES (' �\�\�\�\�\'); INSERT INTO `�s�R` VALUES (' �\�\�\�\�\'); INSERT INTO `�s�R` VALUES (' �\�\�\�\�\'); # Double byte spaces are not supposed to be trimed INSERT INTO `�s�R` VALUES ('�@�\�\�\�\�\'); INSERT INTO `�s�R` VALUES ('�@�@�\�\�\�\�\'); INSERT INTO `�s�R` VALUES ('�@�@�@�\�\�\�\�\'); INSERT INTO `�s�S` VALUES ('�����'); INSERT INTO `�s�S` VALUES (' �����'); INSERT INTO `�s�S` VALUES (' �����'); INSERT INTO `�s�S` VALUES (' �����'); # Double byte spaces are not supposed to be trimed INSERT INTO `�s�S` VALUES ('�@�����'); INSERT INTO `�s�S` VALUES ('�@�@�����'); INSERT INTO `�s�S` VALUES ('�@�@�@�����'); INSERT INTO `�s�T` VALUES ('����������'); INSERT INTO `�s�T` VALUES (' ����������'); INSERT INTO `�s�T` VALUES (' ����������'); INSERT INTO `�s�T` VALUES (' ����������'); # Double byte spaces are not supposed to be trimed INSERT INTO `�s�T` VALUES ('�@����������'); INSERT INTO `�s�T` VALUES ('�@�@����������'); INSERT INTO `�s�T` VALUES ('�@�@�@����������'); INSERT INTO `�s�U` VALUES ('�\�\�\�\�\'); INSERT INTO `�s�U` VALUES (' �\�\�\�\�\'); INSERT INTO `�s�U` VALUES (' �\�\�\�\�\'); INSERT INTO `�s�U` VALUES (' �\�\�\�\�\'); # Double byte spaces are not supposed to be trimed INSERT INTO `�s�U` VALUES ('�@�\�\�\�\�\'); INSERT INTO `�s�U` VALUES ('�@�@�\�\�\�\�\'); INSERT INTO `�s�U` VALUES ('�@�@�@�\�\�\�\�\'); INSERT INTO `�s�V` VALUES ('�����'); INSERT INTO `�s�V` VALUES (' �����'); INSERT INTO `�s�V` VALUES (' �����'); INSERT INTO `�s�V` VALUES (' �����'); # Double byte spaces are not supposed to be trimed INSERT INTO `�s�V` VALUES ('�@�����'); INSERT INTO `�s�V` VALUES ('�@�@�����'); INSERT INTO `�s�V` VALUES ('�@�@�@�����'); INSERT INTO `�s�W` VALUES ('����������'); INSERT INTO `�s�W` VALUES (' ����������'); INSERT INTO `�s�W` VALUES (' ����������'); INSERT INTO `�s�W` VALUES (' ����������'); # Double byte spaces are not supposed to be trimed INSERT INTO `�s�W` VALUES ('�@����������'); INSERT INTO `�s�W` VALUES ('�@�@����������'); INSERT INTO `�s�W` VALUES ('�@�@�@����������'); INSERT INTO `�s�X` VALUES ('�\�\�\�\�\'); INSERT INTO `�s�X` VALUES (' �\�\�\�\�\'); INSERT INTO `�s�X` VALUES (' �\�\�\�\�\'); INSERT INTO `�s�X` VALUES (' �\�\�\�\�\'); # Double byte spaces are not supposed to be trimed INSERT INTO `�s�X` VALUES ('�@�\�\�\�\�\'); INSERT INTO `�s�X` VALUES ('�@�@�\�\�\�\�\'); INSERT INTO `�s�X` VALUES ('�@�@�@�\�\�\�\�\'); #InnoDB SELECT LTRIM(`�b�P`) from `�s�P`; SELECT LTRIM(`�b�P`) from `�s�Q`; SELECT LTRIM(`�b�P`) from `�s�R`; #MyISAM SELECT LTRIM(`�b�P`) from `�s�S`; SELECT LTRIM(`�b�P`) from `�s�T`; SELECT LTRIM(`�b�P`) from `�s�U`; #MEMORY SELECT LTRIM(`�b�P`) from `�s�V`; SELECT LTRIM(`�b�P`) from `�s�W`; SELECT LTRIM(`�b�P`) from `�s�X`; DROP TABLE `�s�P`; DROP TABLE `�s�Q`; DROP TABLE `�s�R`; DROP TABLE `�s�S`; DROP TABLE `�s�T`; DROP TABLE `�s�U`; DROP TABLE `�s�V`; DROP TABLE `�s�W`; DROP TABLE `�s�X`;
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 |
|