MySQL Forums
Forum List  »  Newbie

Union statements
Posted by: freddie
Date: April 28, 2005 03:19AM

I am trying to create a union statement to join two queries together.

one of the fields on one of the queries is a constant, ie because it is from the table i want it to output the letter 'B'. When i try to union this with a variable in another query, i get the error: "Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'UNION'"

can anyone help?

Thanks.

Options: ReplyQuote


Subject
Written By
Posted
Union statements
April 28, 2005 03:19AM
April 28, 2005 03:25AM


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.