Skip to content
@jarnoan

@jarnoan

Jarno Antikainen, an Experienced Software Engineer.

Category: Databases

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.

Posted on January 31, 2019January 31, 2019

Learned today: How to use row_number with MySQL/MariaDB

I’m not going to explain it here, there are plenty of tutorials in the net. But I did findĀ a possible bug in MariaDB and filed an issue.

I was trying to create a database migration in SQL, to add some events for entities that are saved in the database using event sourcing.

 

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

  • 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
  • Richard 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