Re: Default collation used in STRCMP() function
Posted by:
Rick James
Date: August 27, 2012 08:08PM
With utf8_general_ci, 'D1' = 'd1', so I would not expect ts2 to be set. Your use of the COLLATE clause was the 'right' solution.
> both sides are UNICODE
There is an ambiguity here. Technically, "unicode" is "encoded" as utf or ucs. Perhaps that means that "unicode" covers all the utf and ucs character sets. Or perhaps it is meaning something else.
> If both sides are Unicode, or both sides are not Unicode, it is an error.
I don't know what that means.
Subject
Views
Written By
Posted
3717
August 25, 2012 01:17AM
1866
August 26, 2012 09:11PM
3002
August 26, 2012 11:09PM
Re: Default collation used in STRCMP() function
2404
August 27, 2012 08:08PM
1870
August 27, 2012 10:18PM
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.