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

Written By
June 12, 2006 10:52AM
Re: Union Fails due to character sets
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.