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

Truncate text values correctly before insertion into Oracle database

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Minor
    • Resolution: Duplicate
    • 2.2.16rc1, 3.0.6rc1, 3.2.2rc1, 3.4.0alpha1
    • None

    Description

      From Oracle documentation:

      The maximum column size allowed is 4000 characters when the national character set is UTF8 and 2000 when it is AL16UTF16. The maximum length of an NVARCHAR2 column in bytes is 4000. Both the byte limit and the character limit must be met, so the maximum number of characters that is actually allowed in an NVARCHAR2 column is the number of characters that can be written in 4000 bytes.

      We use nvarchar2(2048) a lot across our Oracle DB schema, and AFAIK check only number-of-characters limit. However, with abundance of national characters a 2048 character UTF-8 string can be more than 4000 bytes long.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              glebs.ivanovskis Glebs Ivanovskis (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: