Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-6301

Make schema string field length configurable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.4.0.1
    • Fix Version/s: 5.4.2-RC1, 5.4.2
    • Component/s: None
    • 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.

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.