No need to update in core files, please follow up my solution. Open Mysql database and select database and use below queries. This query also will be useful to find out the datatype CHAR error when upgrade to Magento 2.3.
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE DATA_TYPE ='enum';
Then the table will be list, after that you have to update the column datatype to the acceptable data type like varchar,etc.
Eg: ALTER TABLE
table_name
CHANGEMODIFYcolumn_name
VARCHAR(10);
Note: Update only magento table if you have the result using search query not other mysql table.
Try this, thumps up.