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

Details

    • Incident report
    • Status: Closed
    • Major
    • Resolution: Won't fix
    • 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

    Description

      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

      Attachments

        1. gen.pl.diff
          0.4 kB
          Daniel Petzen

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: