How to get SELECT COERCIBILITY(xxx)=1?
Posted by: Huanting Liu
Date: September 06, 2016 10:07PM

Hi there.


It says:
「The concatenation of two strings with different collations has a coercibility of 1.」

What is 「The concatenation of two strings」? CONCAT?

But I can't get '1' from any result of COERCIBILITY(CONCAT(xx,xx)).

How can I get SELECT COERCIBILITY(xxx)=1?

Any help is appreciated.

Options: ReplyQuote

Written By
How to get SELECT COERCIBILITY(xxx)=1?
September 06, 2016 10:07PM

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.