The UNION operator is also collation sensitive, and all string operands and the final result is assigned the collation of the operand with the highest precedence.

• UNION运算符也区分排序规则,且所有字符串操作数和最终结果被赋以具有最高优先顺序的操作数的排序规则。