MariaDB

Prostoprogramski fork popularne odprtokodne MySQL podatkovne baze.

Sprememba kodiranja znakov

  1. Na ravni tabele
ALTER TABLE mailinglist CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_slovenian_ci;
  1. Na ravni baze
ALTER DATABASE mailman3 CHARACTER SET utf8mb4 COLLATE utf8mb4_slovenian_ci;
  1. Na ravni stolpca
ALTER TABLE mailinglist MODIFY <column_name> VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;