Efficient case-insensitive search with DB2 pureXML
Search and order XML data in a case-insensitive manner
From the developerWorks archives
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.