utf8mb4 introducer added to generated column expression
Posted by: Jason Brunette
Date: October 19, 2022 09:44AM

Stock MySQL 8.0.31, Linux

CREATE TABLE `test` (
`id` int NOT NULL AUTO_INCREMENT,
`test_col` VARCHAR(45) GENERATED ALWAYS AS ("test value"),
PRIMARY KEY (`id`)
) ENGINE=InnoDB;
SELECT GENERATION_EXPRESSION FROM information_schema.columns WHERE TABLE_NAME="test" AND COLUMN_NAME="test_col";

GENERATION_EXPRESSION = _utf8mb4\'test value\'

Why does test_col's GENERATION_EXPRESSION gain the _utf8mb4 introducer? Is there something I can do to prevent this? My app has a technical need for this to not happen. Plus, this seems unnecessary with everything in MySQL 8 defaulting to utf8mb4. This began when we migrated from MySQL 5.7 to MySQL 8.0.31.

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
utf8mb4 introducer added to generated column expression
34
October 19, 2022 09:44AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.