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

    XMLWordPrintable

    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."

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              jostein.knudsen-obsolete@ez.no Jostein Knudsen (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated: