Uploaded image for project: 'Red Hat Data Grid'
  1. Red Hat Data Grid
  2. JDG-578

Collation not set properly when data stored via Hot Rod when JdbcStringBasedStore is used with MariaDB

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • JDG 7.1.0 GA
    • JDG 7.1.0 DR2
    • None
    • None
    • ER2
    • Workaround Exists
    • Hide

      There are two options:

      1. Use the MySQL JDBC driver instead of the official MariaDB one.
      2. Explicitly set the collation and character set of either the database, table involved, or the table column used to store the string key before infinispan starts interacting with the DB. I believe different collation and character combos can be combined, however forcing utf8 seems to cause the least amount of problems:
        character-set-server=utf8mb4
        collation-server=utf8mb4_unicode_ci
      Show
      There are two options: Use the MySQL JDBC driver instead of the official MariaDB one. Explicitly set the collation and character set of either the database, table involved, or the table column used to store the string key before infinispan starts interacting with the DB. I believe different collation and character combos can be combined, however forcing utf8 seems to cause the least amount of problems: character-set-server=utf8mb4 collation-server=utf8mb4_unicode_ci

          remerson@redhat.com Ryan Emerson
          jholusa Jiří Holuša (Inactive)
          Votes:
          0 Vote for this issue
          Watchers:
          2 Start watching this issue

            Created:
            Updated:
            Resolved: