Error importing mysqldump with incorrect string value

[timsehn]

Potential customer reports not being able to import a dump that works in MySQL.

Error is:

ERROR 1105 (HY000) at line 2517838: incorrect string value: '[111 114 103 46 115 112 114 105 110 103 102 114 97 109 101 119 111 114 107 46 111 114 109 46 106 112 97 46 74 112 97 83 121 115 116 101 109 69 120 99 101 112 116 105 111 110 58 32 99 111 117 108 100 32 110 111 116 32 101 120 101 99 117 116 101 32 113 117 101 114 121 59 32 110 101 115 116 101 100 32 101 120 99 101 112 116 105 111 110 32 105 115 32 111 114 103 46 104 105 98 101 114 110 97 116 101 46 101 120 99 101 112 116 105 111 110 46 71 101 110 101 114 105 99 74 68 66 67 69 120 99

Looks like a potential string termination issue.

The customer may be able to provide the scrubbed table schema but will not be able to provide the query or the dumpfile so we may have some trouble reproing this.

[timsehn]

From Max:

this is triggered when the column is a varchar and the value is not utf-8

[timsehn]

From the private schema the customer shared, it seems that the table has a latin1 encoding and individual varchar columns have utf8mb4 encoding. I wonder if Dolt is not overriding column charsets from the table charset.

[Hydrocharged]

This is potentially fixed by https://github.com/dolthub/go-mysql-server/pull/2758