SELECT t.*, ot.Name FROM table t JOIN othertable ot ON t.id = ot.id2 COLLATE latin1_general_ci; -- Choose a common collation here