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

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Unresolved
    • None
    • Component/s: None
    • None
    • 2
    • 15

      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

            Assignee:
            Unassigned
            Reporter:
            Dayana (Inactive)
            Votes:
            12 Vote for this issue
            Watchers:
            16 Start watching this issue

              Created:
              Updated: