MySQL collation errors #11786

720720 · 2022-02-22T08:32:15Z

720720
Feb 22, 2022

Preflight Checklist

I have completed all Troubleshooting Steps.
I'm on the latest version of Directus.
There's no other issue that already describes my problem.

Describe the Bug

2d0c23d

my.cnf character_set_server = utf8mb4 collation_server = utf8mb4_general_ci
.env NO DB_CHARSET

warning for directus tables utf8mb4_bin

my.cnf character_set_server = utf8mb4 collation_server = utf8mb4_general_ci
.env DB_CHARSET="utf8mb4"

warning for directus tables utf8mb4_bin

my.cnf character_set_server = utf8mb4 collation_server = utf8mb4_unicode_ci
.env NO DB_CHARSET

warning for directus tables utf8mb4_bin

my.cnf character_set_server = utf8mb4 collation_server = utf8mb4_unicode_ci
.env DB_CHARSET="utf8mb4"

warning for directus tables utf8mb4_bin
warning for directus tables utf8mb4_general_ci
warning for collection tables created by directus utf8mb4_general_ci
warning for custom tables != utf8mb4_unicode_ci

This commit will show warning messages for any directus installation.
Are directus table collation warnings necessary?
Do directus and custom tables need the same collation?
Is there any problem as long as custom tables have the same collation independent of the databases default?

To Reproduce

npm install directus --production --no-optional
npm install mysql --production
npx directus bootstrap

Errors Shown

root@debian /s/h/directus# /usr/bin/node /srv/http/directus/node_modules/.bin/directus start
09:24:21 ⚠️ PUBLIC_URL should be a full URL
09:24:21 ⚠️ Some tables and columns do not match your database's default collation (utf8mb4_unicode_ci):
- Table "directus_users": "utf8mb4_unicode_ci"
- Column "tags": "utf8mb4_bin"
- Column "auth_data": "utf8mb4_bin"
- Table "directus_presets": "utf8mb4_unicode_ci"
- Column "layout_query": "utf8mb4_bin"
- Column "layout_options": "utf8mb4_bin"
- Column "filter": "utf8mb4_bin"
- Table "directus_files": "utf8mb4_unicode_ci"
- Column "metadata": "utf8mb4_bin"
- Table "directus_settings": "utf8mb4_unicode_ci"
- Column "storage_asset_presets": "utf8mb4_bin"
- Column "basemaps": "utf8mb4_bin"
- Column "module_bar": "utf8mb4_bin"
- Table "directus_revisions": "utf8mb4_unicode_ci"
- Column "data": "utf8mb4_bin"
- Column "delta": "utf8mb4_bin"
- Table "directus_webhooks": "utf8mb4_unicode_ci"
- Column "headers": "utf8mb4_bin"
- Table "directus_permissions": "utf8mb4_unicode_ci"
- Column "permissions": "utf8mb4_bin"
- Column "validation": "utf8mb4_bin"
- Column "presets": "utf8mb4_bin"
- Table "directus_panels": "utf8mb4_unicode_ci"
- Column "options": "utf8mb4_bin"
- Table "directus_fields": "utf8mb4_unicode_ci"
- Column "options": "utf8mb4_bin"
- Column "display_options": "utf8mb4_bin"
- Column "translations": "utf8mb4_bin"
- Column "conditions": "utf8mb4_bin"
- Table "directus_collections": "utf8mb4_unicode_ci"
- Column "translations": "utf8mb4_bin"
- Column "item_duplication_fields": "utf8mb4_bin"

09:24:21 ✨ Server started at http://localhost:8055

What version of Directus are you using?

9.5.1

What version of Node.js are you using?

16.13.2

What database are you using?

MariaDB 10.5.12

What browser are you using?

Firefox 97

What operating system are you using?

Debian 11

How are you deploying Directus?

Locally

azrikahar · 2022-02-22T08:50:27Z

azrikahar
Feb 22, 2022

Moving this to discussion as it's more so a question, and the PR itself and a response to your previous semi-related ticket does touch upon on it, but perhaps @Oreilles can shed more light on the questions/doubts you may have.

0 replies

rijkvanzanten · 2022-02-28T17:22:36Z

rijkvanzanten
Feb 28, 2022
Maintainer

Directus warns you if your tables aren't in the same collation as the database default. This is because Directus will rely on the database default collation when creating new tables/columns, which can cause conflicts when you try to make relationships between tables/columns created in Directus and the ones in the database.

8 replies

rijkvanzanten Mar 3, 2022
Maintainer

Hence the warnings right? The tables/columns in your database are using utf8mb4_bin, which is different from the globally configured default utf8mb4_unicode_ci

720720 Mar 7, 2022
Author

@rijkvanzanten @Oreilles

Every new Directus installation > 9.5.1 will report some of its own tables.

rijkvanzanten Mar 11, 2022
Maintainer

Every new Directus installation > 9.5.1 will report some of its own tables.

That totally depends on your current database configuration.. Directus doesn't set anything explicitly, so will fallback to whatever the database itself is configured to. In the validation check, it simply checks if the table collations match the collation of @@collation_database as that's what the mysql package defaults to as well

directus/api/src/database/index.ts

Line 279 in d987b06

    
           const { collation } = await database.select(database.raw(`@@collation_database as collation`)).first();

720720 Mar 17, 2022
Author

@@character_set_database	@@collation_database
latin1	latin1_swedish_ci

On Debian 11 and MariaDB 10.5.12 all Directus LONGTEXT columns have the collation utf8mb4_bin independent of my database charset and collation settings.

martin-braun Jun 16, 2024

Am I at risk of getting the same non-sense issue when working with PostgreSQL?

720720 · 2022-03-04T09:39:25Z

720720
Mar 4, 2022
Author

Debian 11
MariaDB 10.5.12

/etc/mysql/my.cnf

[client]
default_character_set = utf8mb4

[mysql]
default_character_set = utf8mb4

[mysqld]
character_set_server = utf8mb4
collation_server = utf8mb4_unicode_ci

/srv/http/directus/.env

PORT="8055"

DB_CLIENT="mysql"
DB_HOST="localhost"
DB_PORT="3306"
DB_DATABASE="directus"
DB_USER="directus"
DB_PASSWORD="directus"

mysql -e "CREATE DATABASE directus CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"

mkdir -p /srv/http/directus/uploads
cd /srv/http/directus

npm install directus --production --no-optional
npm install mysql --production
npx directus bootstrap

/usr/bin/node /srv/http/directus/node_modules/.bin/directus start

2d0c23d generates utf8mb4_bin warnings on a clean directus installation

the database api should not report tables that directus bootstrap creates
directus bootstrap should not create tables that the database api reports

3 replies

cpt-n3mo Mar 14, 2022

im having the same trouble with the latest docker image and using a fresh mariadb container.
this happens with fresh project!
cant make any relations ,
cant use image relations either, cant even remove the image relation once it created.. so this error sort of makes it unusable..

 00:45:24 ⚠️  Some tables and columns do not match your database's default collation (utf8mb4_general_ci):
 		- Table "directus_collections": "utf8mb4_general_ci"
 		  - Column "translations": "utf8mb4_bin"
 		  - Column "item_duplication_fields": "utf8mb4_bin"
 		- Table "directus_files": "utf8mb4_general_ci"
 		  - Column "metadata": "utf8mb4_bin"
 		- Table "directus_settings": "utf8mb4_general_ci"
 		  - Column "storage_asset_presets": "utf8mb4_bin"
 		  - Column "basemaps": "utf8mb4_bin"
 		  - Column "module_bar": "utf8mb4_bin"
 		- Table "directus_fields": "utf8mb4_general_ci"
 		  - Column "options": "utf8mb4_bin"
 		  - Column "display_options": "utf8mb4_bin"
 		  - Column "translations": "utf8mb4_bin"
 		  - Column "conditions": "utf8mb4_bin"
 		- Table "directus_webhooks": "utf8mb4_general_ci"
 		  - Column "headers": "utf8mb4_bin"
 		- Table "directus_panels": "utf8mb4_general_ci"
 		  - Column "options": "utf8mb4_bin"
 		- Table "directus_users": "utf8mb4_general_ci"
 		  - Column "tags": "utf8mb4_bin"
 		  - Column "auth_data": "utf8mb4_bin"
 		- Table "directus_presets": "utf8mb4_general_ci"
 		  - Column "layout_query": "utf8mb4_bin"
 		  - Column "layout_options": "utf8mb4_bin"
 		  - Column "filter": "utf8mb4_bin"
 		- Table "directus_permissions": "utf8mb4_general_ci"
 		  - Column "permissions": "utf8mb4_bin"
 		  - Column "validation": "utf8mb4_bin"
 		  - Column "presets": "utf8mb4_bin"
 		- Table "directus_revisions": "utf8mb4_general_ci"
 		  - Column "data": "utf8mb4_bin"
 		  - Column "delta": "utf8mb4_bin"

anyone have a solution for this..?

simonmaris Mar 24, 2022

same here

nightlyworker Mar 31, 2022

Solved with:
create DATABASE XXXXX CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

domjag · 2022-03-16T16:50:36Z

domjag
Mar 16, 2022

Had the same issue on a fresh install:
Windows 10 Xampp: Maria DB 10.4.13
Created DB with utf8mb4_general_ci - Gave me the same error: Some tables and columns do not match your database's default collation (utf8mb4_general_ci): every table pooched.
-removed everything and started over but this time I set charset to utf8mb4_bin - no issues with tables

2nd issue: env variable was set to 0.0.0.0 instead of 127.0.0.1 after fresh install -had to manually correct it. Then everything ran ok.

0 replies

720720 · 2022-03-17T15:39:50Z

720720
Mar 17, 2022
Author

Debian 11
MariaDB 10.5.12

/etc/mysql/my.cnf

[client]
default_character_set = latin1

[mysqld]
character_set_server = latin1
collation_server = latin1_swedish_ci

mysql -e "CREATE DATABASE directus CHARACTER SET latin1 COLLATE latin1_swedish_ci;"

mkdir -p /srv/http/directus/uploads
cd /srv/http/directus

npm install directus --production --no-optional
npm install mysql --production
npx directus bootstrap

/usr/bin/node /srv/http/directus/node_modules/.bin/directus start

15:58:49 ⚠️ Some tables and columns do not match your database's default collation (latin1_swedish_ci):
- Table "directus_users": "latin1_swedish_ci"
- Column "tags": "utf8mb4_bin"
- Column "auth_data": "utf8mb4_bin"
- Table "directus_presets": "latin1_swedish_ci"
- Column "layout_query": "utf8mb4_bin"
- Column "layout_options": "utf8mb4_bin"
- Column "filter": "utf8mb4_bin"
- Table "directus_files": "latin1_swedish_ci"
- Column "metadata": "utf8mb4_bin"
- Table "directus_settings": "latin1_swedish_ci"
- Column "storage_asset_presets": "utf8mb4_bin"
- Column "basemaps": "utf8mb4_bin"
- Column "module_bar": "utf8mb4_bin"
- Table "directus_revisions": "latin1_swedish_ci"
- Column "data": "utf8mb4_bin"
- Column "delta": "utf8mb4_bin"
- Table "directus_webhooks": "latin1_swedish_ci"
- Column "headers": "utf8mb4_bin"
- Table "directus_permissions": "latin1_swedish_ci"
- Column "permissions": "utf8mb4_bin"
- Column "validation": "utf8mb4_bin"
- Column "presets": "utf8mb4_bin"
- Table "directus_panels": "latin1_swedish_ci"
- Column "options": "utf8mb4_bin"
- Table "directus_fields": "latin1_swedish_ci"
- Column "options": "utf8mb4_bin"
- Column "display_options": "utf8mb4_bin"
- Column "translations": "utf8mb4_bin"
- Column "conditions": "utf8mb4_bin"
- Table "directus_collections": "latin1_swedish_ci"
- Column "translations": "utf8mb4_bin"
- Column "item_duplication_fields": "utf8mb4_bin"

@@character_set_database	@@collation_database
latin1	latin1_swedish_ci

On Debian 11 and MariaDB 10.5.12 all Directus LONGTEXT columns have the collation utf8mb4_bin independent of my database charset and collation settings.

1 reply

piotr-cz Aug 1, 2022

Same with MariaDB 10.4

@@character_set_database	@@collation_database
utf8mb4	utf8mb4_unicode_ci

piotr-cz · 2022-08-01T14:25:55Z

piotr-cz
Aug 1, 2022

It seems that after running npx directus bootstrap some table columns are created with utf8mb4_bin collation.
This affects all columns with Datatype: LONGTEXT

The utf8mb4_bin is first of utf8mb4_* collations so I'd say that because of a bug first collation in list is picked instead of database collation.

Database: MariaDB 10.4, doesn't happen in MySQL 5.7

7 replies

piotr-cz Aug 2, 2022

I think it's safe to change columns collation manually to database default.
At least I didn't find any side effects yet.

derrickmehaffy Oct 4, 2023

Since the Directus team don't want to fix the issue, if someone needs to build a quick script to do this, here you go (for non MariaDB users, change the charset and collate as needed.

ALTER DATABASE directus CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

ALTER TABLE directus.directus_panels MODIFY COLUMN `options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_fields MODIFY COLUMN `options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_fields MODIFY COLUMN `display_options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_fields MODIFY COLUMN `translations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_fields MODIFY COLUMN `conditions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_fields MODIFY COLUMN `validation` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_users MODIFY COLUMN `tags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_users MODIFY COLUMN `auth_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_revisions MODIFY COLUMN `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_revisions MODIFY COLUMN `delta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_flows MODIFY COLUMN `options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_settings MODIFY COLUMN `storage_asset_presets` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_settings MODIFY COLUMN `basemaps` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_settings MODIFY COLUMN `module_bar` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_settings MODIFY COLUMN `custom_aspect_ratios` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_webhooks MODIFY COLUMN `headers` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_collections MODIFY COLUMN `translations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_collections MODIFY COLUMN `item_duplication_fields` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_operations MODIFY COLUMN `options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_permissions MODIFY COLUMN `permissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_permissions MODIFY COLUMN `validation` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_permissions MODIFY COLUMN `presets` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_files MODIFY COLUMN `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_presets MODIFY COLUMN `layout_query` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_presets MODIFY COLUMN `layout_options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_presets MODIFY COLUMN `filter` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

fusscreme Oct 21, 2023

dont' forget ALTER DATABASE directus CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; and then npx directus database migrate:latest

derrickmehaffy Oct 21, 2023

dont' forget ALTER DATABASE directus CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; and then npx directus database migrate:latest

Added, thanks

krga Jun 15, 2024

Thanks @derrickmehaffy & @fusscreme

If successfully executed the SQL statements & did the DB migration. Here I've found some tables that still were not fixed (directus_settings & directus_users). Here is my full SQL statement which removes the DB warning;

ALTER DATABASE directus CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

ALTER TABLE directus.directus_panels MODIFY COLUMN `options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_fields MODIFY COLUMN `options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_fields MODIFY COLUMN `display_options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_fields MODIFY COLUMN `translations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_fields MODIFY COLUMN `conditions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_fields MODIFY COLUMN `validation` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_users MODIFY COLUMN `tags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_users MODIFY COLUMN `auth_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_revisions MODIFY COLUMN `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_revisions MODIFY COLUMN `delta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_flows MODIFY COLUMN `options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_settings MODIFY COLUMN `storage_asset_presets` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_settings MODIFY COLUMN `basemaps` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_settings MODIFY COLUMN `module_bar` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_settings MODIFY COLUMN `custom_aspect_ratios` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_webhooks MODIFY COLUMN `headers` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_collections MODIFY COLUMN `translations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_collections MODIFY COLUMN `item_duplication_fields` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_operations MODIFY COLUMN `options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_permissions MODIFY COLUMN `permissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_permissions MODIFY COLUMN `validation` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_permissions MODIFY COLUMN `presets` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_files MODIFY COLUMN `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_presets MODIFY COLUMN `layout_query` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_presets MODIFY COLUMN `layout_options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_presets MODIFY COLUMN `filter` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_settings MODIFY COLUMN `theme_light_overrides` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_settings MODIFY COLUMN `theme_dark_overrides` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_settings MODIFY COLUMN `public_registration_email_filter` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

ALTER TABLE directus.directus_users MODIFY COLUMN `theme_light_overrides` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;
ALTER TABLE directus.directus_users MODIFY COLUMN `theme_dark_overrides` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL NULL;

piotr-cz · 2024-06-17T08:16:50Z

piotr-cz
Jun 17, 2024

I've created #14787 to fix this issue, which is now closed.
If anyone would like to take it over, please do so.

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

MySQL collation errors #11786

{{title}}

Replies: 7 comments 19 replies

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

{{title}}

Select a reply

MySQL collation errors #11786

Preflight Checklist

Describe the Bug

To Reproduce

Errors Shown

What version of Directus are you using?

What version of Node.js are you using?

What database are you using?

What browser are you using?

What operating system are you using?

How are you deploying Directus?

Replies: 7 comments · 19 replies

rijkvanzanten Feb 28, 2022 Maintainer

rijkvanzanten Mar 3, 2022 Maintainer

720720 Mar 7, 2022 Author

rijkvanzanten Mar 11, 2022 Maintainer

720720 Mar 17, 2022 Author

720720 Mar 4, 2022 Author

720720 Mar 17, 2022 Author

Replies: 7 comments 19 replies

rijkvanzanten
Feb 28, 2022
Maintainer

rijkvanzanten Mar 3, 2022
Maintainer

720720 Mar 7, 2022
Author

rijkvanzanten Mar 11, 2022
Maintainer

720720 Mar 17, 2022
Author

720720
Mar 4, 2022
Author

720720
Mar 17, 2022
Author