Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-18147

Wrong character set detection logic for Oracle DB

    XMLWordPrintable

    Details

    • Team:
      Team I
    • Sprint:
      Sprint 66 (Jul 2020)
    • Story Points:
      1

      Description

      Logic for checking character encoding with Oracle DB is wrong in server and frontend.

      Oracle has two character set variables that we check: NLS_CHARACTERSET & NLS_NCHAR_CHARACTERSET.

      We check that both of these are UTF8, which is wrong.

      1. Oracle uses UTF8 name for CESU-8. Proper UTF8 encoding is called AL32UTF8.
      2. We assume that both NLS_CHARACTERSET & NLS_NCHAR_CHARACTERSET have the same value. This may not be the case.

      Suggest allowing AL32UTF8 & UTF8 (CESU-8). The latter should be supported for backwards compatibility with existing installations.

        Attachments

          Activity

            People

            Assignee:
            yurii Jurijs Klopovskis
            Reporter:
            yurii Jurijs Klopovskis
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: