Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-29229

oracle10 entity definition should use VARCHAR2(xx CHAR) instead of VARCHAR2 (xx)

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Low Low
    • None
    • 5.1.1
    • Installation
    • Oracle 11g, Ubuntu 11.10

      During import of XML data i got the error that the column "SUMMARY" of the table "JIRAISSUES" is too small for 259 characters (defined for 255).
      This is because there are some Unicode characters in the summary which had exceeded the size of 255 bytes (but not chars)

      To solve the problem i had to drop the new database and modify the oracle10 entity definition file where i had to change all VARCHAR2(xx) to VARCHAR2(xx CHAR).
      Then the schema got created and i could import all data without a hassle.

      More information:
      http://stackoverflow.com/questions/81448/difference-between-byte-and-char-in-column-datatypes

              Unassigned Unassigned
              ef9225dc3638 Thomas Hackel
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: