Select statement using Chinese characters

i have a table store chinese address and english address i need to select address for compare which address do not same.

when i select english address can compare which one different but chinese address cannot.

anybody advise? thanks

For Example:

output:
id  t1.address  t2.address
1   一三        一三
2   三三        三五

i want to output

id  t1.address  t2.address 
2   三三        三五

Answer

Ok, you can use left join like below sample

SELECT
    t1.id,
    t1.address AS t1address,
    t2.address AS t2address 
FROM
    t1
    LEFT JOIN t2 ON t1.id = t2.id 
WHERE
    t1.address != t2.address