Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27498

Incorrect string value: '\xF4\x80\x80\x83 for character set utf8mb4

    XMLWordPrintable

    Details

      Description

      Hello,

      when inserting a Unicode text into a longtext database field, I get the error message for the character F4808083:

      System.Exception: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF4\x80\x80\x83 f...' for column `hzowork`.`document`.`dataContent` at row 1
      

      According to my research on the Internet, the Unicode character F4808083 is within the allowed range of Unicode according to RFC3629.

      Does the utf8mb4 character set not map the entire valid range according to RFC3629?

      With kind regards
      Karsten

        Attachments

          Activity

            People

            Assignee:
            bar Alexander Barkov
            Reporter:
            KB_Heinze Karsten Budde
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.