Edit File: ctype_cp932.result
# # Bug #11755818 LIKE DOESN'T MATCH WHEN CP932_BIN/SJIS_BIN COLLATIONS ARE # USED. # SET @old_character_set_client= @@character_set_client; SET @old_character_set_connection= @@character_set_connection; SET @old_character_set_results= @@character_set_results; SET character_set_client= 'utf8'; SET character_set_connection= 'utf8'; SET character_set_results= 'utf8'; CREATE TABLE t1 (a VARCHAR(10) COLLATE cp932_bin); INSERT INTO t1 VALUES('ｶｶ'); SELECT * FROM t1 WHERE a LIKE '%ｶ'; a ｶｶ SELECT * FROM t1 WHERE a LIKE '_ｶ'; a ｶｶ SELECT * FROM t1 WHERE a LIKE '%_ｶ'; a ｶｶ ALTER TABLE t1 MODIFY a VARCHAR(100) COLLATE sjis_bin; SELECT * FROM t1 WHERE a LIKE '%ｶ'; a ｶｶ SELECT * FROM t1 WHERE a LIKE '_ｶ'; a ｶｶ SELECT * FROM t1 WHERE a LIKE '%_ｶ'; a ｶｶ DROP TABLE t1; SET @@character_set_client= @old_character_set_client; SET @@character_set_connection= @old_character_set_connection; SET @@character_set_results= @old_character_set_results;
Back to File Manager