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

varchar(N) in IBM DB2 is limited to N bytes rather than N characters

    XMLWordPrintable

    Details

      Description

      According to the following links, varchar(N) is indeed in bytes:

      When trying to insert a value into the database that is N characters, but more than N bytes, it gives the following error:

      IBM DB2 ERROR: [-433] 22001 [[IBM][CLI Driver][DB2/LINUXX8664] SQL0433N  Value "????????? ???????? ? UTF-8..." is too long.  SQLSTATE=22001]
      

      Ideally, if we find a way, we should make it possible to store N characters. If not, we should at least cut the value we are trying to insert to N bytes so that there are no SQL errors.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            asaveljevs Aleksandrs Saveljevs
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: