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

    • Icon: Suggestion Suggestion
    • Resolution: Unresolved
    • None
    • None
    • None
    • 2
    • 14
    • 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.

      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

        1. docs-oracle-marked-paragraphs.png
          docs-oracle-marked-paragraphs.png
          93 kB

              Unassigned Unassigned
              dazmi Dayana (Inactive)
              Votes:
              12 Vote for this issue
              Watchers:
              15 Start watching this issue

                Created:
                Updated: