what happened when compare two different character sets and collations
Posted by: aaron chan
Date: February 26, 2019 04:01AM

I have three tables: tt1,tt2 and tt3.

tt1 has a column which character set = utf8 and collation = utf8_general_ci,
tt2 has a column which character set = utf8mb4 and collation = utf8mb4_unicode_ci,
tt3 has a column which character set = utf8mb4 and collation = utf8mb4_general_ci.

when I compare tt1 and tt2,for example:select * from tt1,tt2 where tt1.col=tt2.col,It works fine.
however when I compare tt2 and tt3 using the select statement,it shows me "Illegal mix of collations".

so what happened where compare two different character sets and collations?

Options: ReplyQuote


Subject
Views
Written By
Posted
what happened when compare two different character sets and collations
1007
February 26, 2019 04:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.