Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-21416

Oracle DB Content Object Name field type size set to Bytes instead of Chars

    Details

      Description

      Regarding Oracle, the installed DB schema states that the Content Object Name field is set to VARCHAR(255). This statement means that the maximum lenght of the field can be 255 BYTES, while the intention according to the documentation is 255 Characters.
      The correct definition would be VARCHAR(255 CHAR), which would adjust the allowed space to the selected character set according to: http://ss64.com/ora/syntax-datatypes.html
      "Oracle9i and above allow Varchar2 columns to be defined as a number of bytes VARCHAR2(50 BYTE) or a number of characters VARCHAR2(50 CHAR), the latter is useful if the database is ever converted to run a double-byte character set (such as Japanese), you won't have to edit the column sizes. The default measure, normally BYTE, is set with nls_length_semantics."

        Issue Links

          Activity

          Hide
          Gaetano Giunta (Inactive) added a comment -

          Note that this applies to all varchar columns in the schema definition...

          Show
          Gaetano Giunta (Inactive) added a comment - Note that this applies to all varchar columns in the schema definition...

            People

            • Assignee:
              Unassigned
              Reporter:
              Jostein Knudsen (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated: