Skip to content

@jarnoan

Jarno Antikainen, an Experienced Software Engineer.

Month: October 2020

Posted on October 19, 2020

Learned today: UTF8 cannot store all of UTF8 in MySQL/MariaDB

You might think that using UTF8 encoding and collation in MySQL or MariaDB would solve the character encoding issues for good. Wrong! In MySQL and MariaDB UTF8 is an alias to UTF8MB3, which means it cannot store four-byte character sequences. Whose idea was that?

So, use UTF8MB4 instead. Sigh.

Recent Posts

  • TIL: split
  • Learned today: UTF8 cannot store all of UTF8 in MySQL/MariaDB
  • Learned today: Creating Grafana dashboard
  • Learned today: How to provide Prometheus metrics in a Go program
  • Learned today: Why DNS failed in Docker swarm containers

Recent Comments

  • Andi on How to restore price suffix for variable product in WooCommerce
  • WP on How to restore price suffix for variable product in WooCommerce
  • Jimmy Atauje Hidalgo on Making SOAP call with named parameters in PHP
  • jarno on How to restore price suffix for variable product in WooCommerce
  • Breda on How to restore price suffix for variable product in WooCommerce

Archives

  • December 2020
  • October 2020
  • January 2020
  • September 2019
  • March 2019
  • February 2019
  • January 2019
  • October 2018
  • May 2018
  • March 2018
  • February 2018
  • December 2017
  • November 2017
  • October 2017

Categories

  • Application Frameworks
    • Apache Cordova
    • Laravel
    • Solid
  • Containers
    • Docker
    • Docker Swarm
  • Content Management Systems
    • WordPress
  • Databases
    • MariaDB
    • MySQL
  • Design patterns
    • Event sourcing
  • DevOps
    • GitLab CI
    • Prometheus
    • Scrutinizer
    • Serverless
    • StyleCI
    • Travis CI
  • E-Commerce Platforms
    • Nosto
    • Smilehouse Workspace
    • WooCommerce
  • Meta
  • Open source contributions
  • Operating Systems
    • Linux
  • Platforms
    • Android
    • AWS
    • Google Cloud Platform
      • Google Cloud Functions
    • Kubernetes
    • Web
  • Programming Languages
    • Go
    • Javascript
    • PHP
    • Shell scripting
    • SQL
  • Test Frameworks
    • PHPUnit
  • Today I learned
  • Uncategorized
  • Version Control
    • Git
    • GitHub
    • GitLab
  • Web servers
    • Apache
    • Nginx

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Proudly powered by WordPress