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

MariaDB 10.6.x set caratteri

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.6
    • N/A
    • Character Sets
    • None

    Description

      Con la versione 10.6 il set di caratteri utf8 è un alias di utf8mb3 e non più utf8mb4.
      Io ho risolto inserendo nel file my.ini:
      old-mode=
      character-set-server=utf8mb4

      poi nelle mie applicazioni in C# dopo la connessione eseguo la query:
      "SET character_set_results=utf8mb4"

      Così ho risolto, ma chiedo:
      1. perchè non funziona la direttiva che posso inserire nel file my.ini
      init-connect='SET character_set_results=utf8mb4;'
      che se ho capito bene dovrebbe essere eseguita ad ogni connessione, ma così non è.
      2. è possibile che tutto questo possa essere deciso in fase di setup, magari con un flag del tipo:
      "forza l'uso di utf8mb4 come character set di default"
      Spero di essermi spiegato bene.
      Grazie


      With version 10.6 the utf8 character set is an alias of utf8mb3 and no longer utf8mb4.
      I solved it by inserting in the my.ini file:
      old-mode =
      character-set-server = utf8mb4

      then in my applications in C # after the connection I execute the query:
      "SET character_set_results = utf8mb4"

      So I solved, but I ask:
      1. because the directive that I can insert in the my.ini file doesn't work
      init-connect = 'SET character_set_results = utf8mb4;'
      that if I understand correctly it should be performed on every connection, but it is not.
      2. it is possible that all this can be decided during the setup phase, perhaps with a flag like:
      "force use of utf8mb4 as default character set"
      I hope I explained myself.
      Thanks

      Attachments

        1. softdevo.vcf
          0.1 kB
        2. jokjnmadjfajgjci.png
          jokjnmadjfajgjci.png
          126 kB
        3. softdevo.vcf
          0.1 kB

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              softdevo@tiscali.it DANILO GIULIANI
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.