UTF8

[Matthijs]

Hi,
in the manual, I read:
UTF8 is the character encoding strongly recommended also for MySQL, PostgreSQL and MS SQL Server.

But all my tables created by Databik show:
latin1_swedish_ci

And this causes problems with inserting characters as é

Question:
1) Change I somewhere changed the default for new tables to UTF8?
2) How can I updated existing tables?

thanks for any help!

Your current DaDaBIK version​

You are using DaDaBIK version 11.10-Elba monthly, installed on 13-07-2023 (installation code: 18828644e443ac0e33), the latest version of DaDaBIK is 11.10-Elba released on 13-07-2023

You are running the latest release of DaDaBIK

In case you want to upgrade to a more powerful edition (from Pro to Enterprise/Platinum, from Enterprise to Platinum) please contact us.

System info​

PHP Version: 8.1.22

mysql version: 10.6.14-MariaDB

Web server: Apache/2

Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36

 

[deep64blue]

But all my tables created by Databik show:
latin1_swedish_ci

This is controlled by your database.

The following command run in phpMyAdmin or directly in MySQL will tell you what your defaults are.

SHOW CREATE DATABASE test;

The following commands will set the defaults going forward:-

SET character_set_server = 'utf8mb4';

SET collation_server = 'utf8_unicode_ci';