| Bug #117181 | Table Data Import Wizard is not utf8 aware | ||
|---|---|---|---|
| Submitted: | 10 Jan 16:14 | Modified: | 13 Jan 8:31 |
| Reporter: | John King | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
| Version: | 8.0.38, 8.0.40 | OS: | Windows (10) |
| Assigned to: | CPU Architecture: | x86 | |
[13 Jan 8:31]
MySQL Verification Team
Hello John, Thank you for the report and feedback. Verified as described. regards, Umesh
Description: Import Table wizard Importing to a char or varchar field from a csv uses byte width instead of char length a text in an utf8 file "Ü" is reported as to long for a char(1) field. How to repeat: create table short as letter char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; csv file containing Ü use table import wizerd to import the file reports - Row import failed with error: ("Data too long for column 'letter' at row 1", 1406) Suggested fix: use UTF8 to read the file