From: Todd G. <tod...@gm...> - 2008-07-26 00:35:16
|
I need case-insensitive order by functionality. I've implemented a FLOWR order by using for $x in /requestPackage order by fn:upper-case(fn:string($x/description)) return $x I'm concerned about performance of the upper-case function. I've found in documentation that collation support has not yet been implemented and only unicode collation is supported. I've found in the mailing list where Wolfgang points to a configuation <indexer caseSensitive="no"> in conf.xml but that he doesn't recommend this approach as it violates the XQuery spec for string functions and operators. I don't believe the full-text index is being used as an optimization of the upper-case function. What's the best practice for implementing case-insensitive sorting of results? Todd |