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

Four byte UTF-8 symbol causes "query failed: [1366] Incorrect string value"

    XMLWordPrintable

    Details

    • Type: Problem report
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 4.0.0alpha4
    • Fix Version/s: None
    • Component/s: Proxy (P), Server (S)
    • Labels:

      Description

      Tested on MariaDB

      Create item with key:

      system.run[printf "\xF0\x90\x8D\x83"]
      
      [Z3005] query failed: [1366] Incorrect string value: '\xF0\x90\x8D\x83' for column 'value' at row 1 [insert into history_text (itemid,clock,ns,value) values (28334,1518796107,577446509,'<symbol that jira does not allow to insert either>');
      

      Not sure if this should be handled in Zabbix server/Zabbix proxy or documented.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              vso Vladislavs Sokurenko
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: