Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-51935

Implement Oracle database schema to accept VARCHAR2 datatype for Confluence database column.

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Unresolved
    • None
    • None
    • None
    • 1
    • 2
    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      NOTE: This suggestion is for Confluence Server. Using Confluence Cloud? See the corresponding suggestion.

      Confluence upgrade task will failed if the pre-upgrade Oracle DB dialect uses column data types that do not support Unicode (VARCHAR data type). This will need a modification of the database column that uses VARCHAR2 datatype to NVARCHAR2 datatype as per knowledge base article below:

      Therefore, it is much convenient if we could implement a schema to accept the VARCHAR2 datatype for ease of upgrading Confluence.

      Snippet from Oracle documentation which recommend using VARCHAR2 over NVARCHAR2 datatype:

      Link: http://docs.oracle.com/database/121/NLSPG/ch6unicode.htm#NLSPG319

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-54048 Confluence instances using Oracle DBMS may not be able to upgrade to version 5.9 and later

          • Low - Low priority issues
          • Gathering Impact
          relates to

          Suggestion - CONFCLOUD-51935 Implement Oracle database schema to accept VARCHAR2 datatype for Confluence database column.

          • Closed
          is blocked by

          PSR-51 Loading...

          Activity

            People

              Unassigned Unassigned
              dazmi Dayana
              Votes:
              7 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated: