Union Fails due to character sets
Posted by: jed davidow
Date: June 12, 2006 10:52AM

I am performing a union of querries. One pulls a varchar field, the other pulls a constant:

SELECT
A,
B,
'SHIPPED' as Status
FROM TABLE_A

UNION

SELECT
A,
B,
C as Status
FROM TABLE_B


I get the following error:

Illegal mix of collations (utf8_general_ci,COERCIBLE)
and (latin1_swedish_ci,IMPLICIT) for operation 'UNION'

How do I deal with this?
Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
Union Fails due to character sets
4719
June 12, 2006 10:52AM


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.