Bug #107736 Invalid utf8mb4 character string warning
Submitted: 2 Jul 14:00 Modified: 3 Jul 14:25
Reporter: Sebastian Lemke Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S3 (Non-critical)
Version:8.0.29, 5.7.38 OS:Linux (Rocky Linux 8.6)
Assigned to: CPU Architecture:x86

[2 Jul 14:00] Sebastian Lemke
Description:
Hello,

I get an 

Warning (Code 1300): Invalid utf8mb4 character string: 'A91CE3'

on Importing a table structure. Could be related to this bug (?):
https://bugs.mysql.com/bug.php?id=80150

See "How to repeat" for details.

Thanks
Sebastian

How to repeat:
CREATE TABLE `sample` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `cms_block_version_id` binary(16) NOT NULL DEFAULT 0x0FA91CE3E96A4BC2BE4BD9CE752C3425,
  `data` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

----

mysqldump --hex-blob --default-character-set=utf8mb4 -p test sample -r sample.sql

----

mysql -p --show-warnings --default-character-set=utf8mb4
use test;
source sample.sql

> Warning (Code 1300): Invalid utf8mb4 character string: 'A91CE3'
[3 Jul 14:25] MySQL Verification Team
Hello Sebastian,

Thank you for the report and test case.

regards,
Umesh