[NXP-6301] Make schema string field length configurable - Nuxeo Issue Tracker

XML

Word

Printable

Impact type:

Configuration format change
Upgrade notes:
Hide

New feature:

To add a specific length to a VARCHAR column used in a directory, use in the schema:

<xs:simpleType name="string50">
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>

<xs:element name="mystring" type="nxs:string50" />

String fields with a length bigger than the maximum length allowed for a VARCHAR will be automatically turned into a CLOB. Actual database limits are:

65535 for MySQL

4000 for SQL Server

2000 for Oracle
You can force use of a CLOB by using maxLength 999999999.
Show
New feature: To add a specific length to a VARCHAR column used in a directory, use in the schema: <xs:simpleType name="string50"> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> <xs:element name="mystring" type="nxs:string50" /> String fields with a length bigger than the maximum length allowed for a VARCHAR will be automatically turned into a CLOB. Actual database limits are: 65535 for MySQL 4000 for SQL Server 2000 for Oracle You can force use of a CLOB by using maxLength 999999999.

We should be able to do:
<simpleType name="myString">
<restriction base="string">
<maxLength value="200"/>
</restriction>
</simpleType>

For directories, this should be creating columns of the given size.
For VCS behavior is to be defined.

depends on

NXP-6442 Implement SQL directories based on current VCS code

is required by

NXP-8026 fix core types with restrictions

NXP-6425 Fix unit tests related to doc signing