Hi Ryan! Good to see you too.
This is on my local machine using Laragon running MySQL 8.
I ran the query:
SELECT * FROM information_schema.SCHEMATA S WHERE schema_name = "aelwenjones";
And it returned:
CATALOG_NAME def
SCHEMA_NAME aelwenjones
DEFAULT_CHARACTER_SET_NAME utf8mb4
DEFAULT_COLLATION_NAME utf8mb4_general_ci
But if on phpMyAdmin I select one table and click on show create I get:
CREATE TABLE `field_article_text` (
`pages_id` int unsigned NOT NULL,
`data` mediumtext NOT NULL,
PRIMARY KEY (`pages_id`),
KEY `data_exact` (`data`(250)),
FULLTEXT KEY `data` (`data`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3
I notice on my host, however, that most of my schemas are latin1, so I need to make sure they aren't, as it were, for this table.