Re: Incorrect String Value

[Tames Bond]

Table: addresses
Create Table: CREATE TABLE 'addresses' (
IDNUM int(8) unsigned zerofill NOT NULL,
Addy varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
Town varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
Desc varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
AstYear varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
PRIMARY KEY ('IDNUM'),
UNIQUE KEY 'IDNUM_UNIQUE' ('IDNUM')
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_0900_ai_cs
1 row in set (0.00 sec)

the error is
ERROR 1366 (HY000): Incorrect string value: '\xE9siden...' for column 'Desc' at row 11

Offending line:
00100298 3271 RTE 202 325 Terrain & Résidence 2021