Efficient case-insensitive search with DB2 pureXML

Search and order XML data in a case-insensitive manner

From the developerWorks archives

Matthias Nicola and Martin Sommerlandt

Date archived: January 12, 2017 | First published: November 13, 2008

The values of XML elements and attributes are, by definition, case sensitive. For example, if you search <city> elements for the value "Paris," you will not find "PARIS" or "paris." This can be solved with XQuery functions such as fn:upper-case(), but the performance will not always be optimal since the use of such functions precludes the use of XML indexes. This article explains how to create a case-insensitive database using DB2® pureXML™ and what behavior to expect for XML queries and XML indexes.

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management, XML
ArticleID=351866
ArticleTitle=Efficient case-insensitive search with DB2 pureXML
publish-date=11132008