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

Nvarchar is set too high in oracle.sql

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Major Major
    • 1.9.0 (alpha)
    • 1.9.0 (alpha)
    • None
    • Trunk version: Trunk version: 8318
      Oracle version 11.07
      Linux 2.6.18-128.el5 #1 SMP Wed Dec 17 11:41:38 EST 2008 x86_64 x86_64 x86_64 GNU/Linux

      The create/schema/gen.pl that generates the SQL statements for Oracle sets the nvarchar2 fields to 2,048, which is very high.

      It failed with the default settings on Oracle 11.07 and is very likely to be a problem at many sites.

      The size required depends on the locale (i.e. character set), but can hopefully be less than 2,048. We got away by setting it to 2,000.

      I'll attach a patch that resolved our problems.

      Regards,
      Dan

        1. gen.pl.diff
          0.4 kB

            kodai Kodai Terashima
            petzend Daniel Petzen
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: