Use contains with case insensitive and diacritic (Orracle 11g)
751500Feb 25 2011 — edited Mar 1 2011Hello to all.
I have a XMLTYPE colum and I'd like to make text search with case insensitive
select d.* from document d WHERE d.XML.existsNode('//field[contains(@value,"preview") and @searchable="true"= 1
I'd like to all case insensitive 'preview'.
In a varchar filed it is possible to set the diacritic/case insensitive search
ALTER SESSION SET NLS_COMP=LINGUISTIC;
ALTER session set nls_sort='binary_ai'; -->accent insensitive
binary_ci -->case insensitive.
but i don't works on XQuery search... any idea?
Cristian