Re: XML Collating sequence

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Just to add to what Bob said, XML uses binary comparisons for comparison (in XQuery) and sorting (the order by clause in FLWOR expressions). Efficient, but does not account for the little things we've grown accustomed to like dictionary sorting, accent insensitivity, case insensitivity, etc.

--

========
Michael Coles
"Pro T-SQL 2008 Programmer's Guide"
http://www.amazon.com/T-SQL-2008-Programmer-rsquo-Guide/dp/143021001X


"Chloe C" <chloe@xxxxxxxxxxxxxxxx> wrote in message news:qafv25prfu5su0m38j7hnuadlia5hha2vj@xxxxxxxxxx
Hi

If we search an XML datatype, does it use the collation properties
from the database, e.g. Case sensitivity, Accent sensitivity?

If it doesn't use the database, is there any other way of affecting
it?

Chloe

.

Relevant Pages

  • Re: Sorting problem
    ... change the type to int16 for the appropriate node or read in the xml as ... Because when sorting, different data type has ... >>> DataColumns' DAtaType in the DataTable. ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Re: sorting a dataset
    ... Ideally, I would like to return the data in structured hierarchical xml, eg: ... I know I can copy my dataset into a dataview and sort the ... >> are sorting a dataview. ...
    (microsoft.public.dotnet.xml)
  • Re: Custom sorting through xslt extension object
    ... > I don't have a source xml but let me give you a scenario. ... the sorting mechanism won't be alphabetical. ... > sorting order may be defined by the application arbitrarily. ...
    (microsoft.public.dotnet.xml)
  • Re: sorting a dataset
    ... Ideally, I would like to return the data in structured hierarchical xml, eg: ... I know I can copy my dataset into a dataview and sort the ... >> are sorting a dataview. ...
    (microsoft.public.dotnet.framework.adonet)