|
|
Posted by Erland Sommarskog on 04/27/06 01:06
John (johnxhc@yahoo.com) writes:
> The XML Datatype does not support the case-insensitive search makes the
> XML DataType (almost) useless, if I stored the xml in the XML column, I
> certainly want to search it, if I could not performance
> case-insensitive search, why do I need store the data in the XML
> column?
Since XQuery in SQL Server closely follows the standard for XQuery, I
guess that the standard says that XML is case-sensitive.
> I try the following:
>
> 1) The fulltext search will not tell you which element has the match
>
> 2) Using Nodes cross Apply, I got the following error:
> The column 'x' that was returned from the nodes() method cannot be used
> directly. It can only be used with one of the four XML datatype methods
> exist(), nodes(), query(), and value() or in IS NULL and IS NOT NULL
> checks.
The error in 2 does not seem to have anything to do with the sensitivity
of case.
It's probably better to post an example of what you want to achieve,
so people can give some useful advice.
Involving microsoft.public.sqlserver.xml may be a good idea too.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|