Need case insensitive ordering by name in dashboard

Hello everyone! I have an issue with sorting columns by name in dashboard view.

What I have

  • query build with MySQL
  • column of type text with utf8mb4_unicode_ci collation

What the problem is

When I click on column header, rows are sorted by name but in case sensitive manner.


  1. ABC
  2. DEF
  3. XYZ
  4. abc
  5. def
  6. xyz

What I expect:

  1. abc
  2. ABC
  3. def
  4. DEF
  5. xyz
  6. XYZ

Is it possible to sort it on dashboard (not SQL)? Am I missing some setting?

Hi @pawelkmpt
Can you post Diagnostic Info from Admin > Troubleshooting?
The sorting done on the dashboard tables are client-side, so it’s a javascript library in the browser - not related to database type or query.
I’ve opened an issue for you: - upvote by clicking :+1: on the first post

  "browser-info": {
    "language": "pl",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36",
    "vendor": "Google Inc."
  "system-info": {
    "": "OpenJDK Runtime Environment",
    "java.runtime.version": "1.8.0_222-b10",
    "java.vendor": "Oracle Corporation",
    "java.vendor.url": "",
    "java.version": "1.8.0_222",
    "": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "25.222-b10",
    "": "Linux",
    "os.version": "2.6.32-754.17.1.el6.x86_64",
    "user.language": "en",
    "user.timezone": "US/Eastern"
  "metabase-info": {
    "databases": [
    "hosting-env": "unknown",
    "application-database": "h2",
    "run-mode": "prod",
    "version": {
      "tag": "v0.33.4",
      "date": "2019-10-07",
      "branch": "release-0.33.x",
      "hash": "9559406"
    "settings": {
      "report-timezone": null

@pawelkmpt Just for your info, latest version is and you should really migrate away from H2 as application database (metadata) in production: