Re: Union Fails due to character sets
Posted by: jed davidow
Date: June 12, 2006 11:16AM

Found it. Sorry for bothering everyone:

CONVERT('SHIPPED' using latin1) as status

Before posting, I tried:
CONVERT('SHIPPED' using latin1_swedish_ci) as status
so I figured it would not work. I was wrong.

Options: ReplyQuote


Subject
Views
Written By
Posted
4718
June 12, 2006 10:52AM
Re: Union Fails due to character sets
2290
June 12, 2006 11:16AM


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.