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 $awhere 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