Hi all,
I have a problem with the collation setting.

The problem is the following:

• the result of the xquery

  declare default collation “collation?language=it;strength=secondary”
  for $a in input()/Index[@type=“author” and @tot>0] sort by (./@order ascending)
  return $a

• is different from the result of the xquery

  for $a in input()/Index[@type=“author” and @tot>0] sort by (./@order ascending)
  return $a

  where the collation is defined in the Index schema

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:tsd=“http://namespaces.softwareag.com/tamino/TaminoSchemaDefinition” xmlns:xs=“XML Schema”>
xs:annotation
xs:appinfo
<tsd:schemaInfo name=“Index”>
<tsd:collection name=“Index”/>
<tsd:doctype name=“Index”>
tsd:logical
tsd:contentclosed</tsd:content>
</tsd:logical>
</tsd:doctype>
tsd:adminInfo
tsd:versionTSD4.2</tsd:version>
tsd:created2005-07-28T09:15:52.912+01:00</tsd:created>
tsd:modified2006-05-11T15:49:53.062+01:00</tsd:modified>
</tsd:adminInfo>
</tsd:schemaInfo>
</xs:appinfo>
</xs:annotation>
<xs:element name=“Index”>
xs:annotation
xs:appinfo
tsd:elementInfo
tsd:logical
tsd:collation
<tsd:language value=“it”/>
<tsd:strength value=“secondary”/>
<tsd:caseFirst value=“off”/>
</tsd:collation>
</tsd:logical>
tsd:physical
tsd:native
tsd:index
tsd:standard/
tsd:text/
</tsd:index>
</tsd:native>
</tsd:physical>
</tsd:elementInfo>
</xs:appinfo>
</xs:annotation>
<xs:complexType mixed=“true”>
<xs:choice minOccurs=“0” maxOccurs=“unbounded”>
<xs:element ref=“subIndex”/>
</xs:choice>
<xs:attribute name=“id” type=“xs:string”>
xs:annotation
xs:appinfo
tsd:attributeInfo
tsd:physical
tsd:native
tsd:index
tsd:standard/
</tsd:index>
</tsd:native>
</tsd:physical>
</tsd:attributeInfo>
</xs:appinfo>
</xs:annotation>
</xs:attribute>
<xs:attribute name=“type” type=“xs:string” use=“required”>
xs:annotation
xs:appinfo
tsd:attributeInfo
tsd:physical
tsd:native
tsd:index
tsd:standard/
</tsd:index>
</tsd:native>
</tsd:physical>
</tsd:attributeInfo>
</xs:appinfo>
</xs:annotation>
</xs:attribute>
<xs:attribute name=“subType” type=“xs:string”/>
<xs:attribute name=“order” type=“xs:string” use=“required”>
xs:annotation
xs:appinfo
tsd:attributeInfo
tsd:logical
tsd:collation
<tsd:language value=“it”/>
<tsd:strength value=“secondary”/>
<tsd:caseFirst value=“off”/>
</tsd:collation>
</tsd:logical>
tsd:physical
tsd:native
tsd:index
tsd:standard/
tsd:text/
</tsd:index>
</tsd:native>
</tsd:physical>
</tsd:attributeInfo>
</xs:appinfo>
</xs:annotation>
</xs:attribute>
<xs:attribute name=“available” type=“xs:integer” use=“required”>
xs:annotation
xs:appinfo
tsd:attributeInfo
tsd:physical
tsd:native
tsd:index
tsd:standard/
</tsd:index>
</tsd:native>
</tsd:physical>
</tsd:attributeInfo>
</xs:appinfo>
</xs:annotation>
</xs:attribute>
<xs:attribute name=“tot” type=“xs:integer” use=“required”>
xs:annotation
xs:appinfo
tsd:attributeInfo
tsd:physical
tsd:native
tsd:index
tsd:standard/
</tsd:index>
</tsd:native>
</tsd:physical>
</tsd:attributeInfo>
</xs:appinfo>
</xs:annotation>
</xs:attribute>
<xs:attribute name=“note” type=“xs:string”/>
<xs:attribute name=“rif” type=“xs:string”/>
</xs:complexType>
</xs:element>
<xs:element name=“subIndex”>
xs:annotation
xs:appinfo
tsd:elementInfo
tsd:logical
tsd:collation
<tsd:language value=“it”/>
<tsd:strength value=“secondary”/>
<tsd:caseFirst value=“off”/>
</tsd:collation>
</tsd:logical>
tsd:physical
tsd:native
tsd:index
tsd:standard/
tsd:text/
</tsd:index>
</tsd:native>
</tsd:physical>
</tsd:elementInfo>
</xs:appinfo>
</xs:annotation>
xs:complexType
xs:simpleContent
<xs:extension base=“xs:string”>
<xs:attribute name=“id” type=“xs:string”>
xs:annotation
xs:appinfo
tsd:attributeInfo
tsd:physical
tsd:native
tsd:index
tsd:standard/
tsd:text/
</tsd:index>
</tsd:native>
</tsd:physical>
</tsd:attributeInfo>
</xs:appinfo>
</xs:annotation>
</xs:attribute>
<xs:attribute name=“subType” type=“xs:string”/>
<xs:attribute name=“available” type=“xs:integer” use=“required”>
xs:annotation
xs:appinfo
tsd:attributeInfo
tsd:physical
tsd:native
tsd:index
tsd:standard/
</tsd:index>
</tsd:native>
</tsd:physical>
</tsd:attributeInfo>
</xs:appinfo>
</xs:annotation>
</xs:attribute>
<xs:attribute name=“tot” type=“xs:integer” use=“required”>
xs:annotation
xs:appinfo
tsd:attributeInfo
tsd:physical
tsd:native
tsd:index
tsd:standard/
</tsd:index>
</tsd:native>
</tsd:physical>
</tsd:attributeInfo>
</xs:appinfo>
</xs:annotation>
</xs:attribute>
<xs:attribute name=“note” type=“xs:string”/>
<xs:attribute name=“rif” type=“xs:string”/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
</xs:schema>

Why is there that difference?

NOTE: In second case the result is the itself one which would be obtained if the collation was not definite in the schema!!! WHY?

Every help is appreciated!
Thanks in advance,

Pam

Excuse me, what i have written in the note is not exact. Please ignore it!
Thanks,

Pam