How come MySQL is not differentiating between these characters? SELECT text_id, us, de, es, fr FROM texts WHERE us = fr;
Results in matching here. Notice the difference in the "scene" vs "scène" text_id us es de fr -------------- ------ ------ --------- -------- all_page_scene scene escena Filmszene scène I wold expect this NOT to match. Do I have to add something to my query to tell MySQL to respect other character sets as different? CREATE TABLE `texts` ( `text_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '', `us` text, `es` text, `de` text, `fr` text, PRIMARY KEY (`text_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 Field Type Collation Null Key Default Extra Privileges Comment ------- ----------- ----------------- ------ ------ ------- ------ ------------------------------- --------- text_id varchar(50) latin1_general_ci NO PRI select,insert,update,references us text utf8_general_ci YES (NULL) select,insert,update,references es text utf8_general_ci YES (NULL) select,insert,update,references de text utf8_general_ci YES (NULL) select,insert,update,references fr text utf8_general_ci YES (NULL) select,insert,update,references -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
