The LIKE operator and charsets/collations
Posted by:
m p
Date: November 29, 2006 05:11AM
Hi,
I thought that the LIKE operator was case sensitive and accent insensitive. That is that a, A, á, Á, à, À, ä, Ä...etc are all considered different.
However in the database (5.0.26) i am working with this is not the case. Having searched the Web i've seen that LIKE is only case insensitive when the column type is marked as BINARY and it would seem that this aplies to the accents aswell?
What i don't understand is whether the charset and/or collation also afects the LIKE operator.
I'm working in UTF-8 with latin1_spanish_ci collation. Would changing this change the behaviour of the LIKE operator.
max
Subject
Views
Written By
Posted
The LIKE operator and charsets/collations
2636
November 29, 2006 05:11AM
1732
December 01, 2006 04:50AM
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.