| Bug #100957 | No Varchar Option in Import Wizard in MySQL Workbench | ||
|---|---|---|---|
| Submitted: | 25 Sep 2020 15:22 | Modified: | 25 Oct 2020 19:30 |
| Reporter: | Sarah Baizer | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
| Version: | 8.0 | OS: | Any |
| Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
| Tags: | 8.0, varchar, wizard | ||
[25 Sep 2020 19:30]
MySQL Verification Team
Thank you for the bug report. Please provide the CREATE TABLE statement (You could see it with SHOW CREATE TABLE table_name) and a small CVS file (attach it using the FILES tab) which is suitable to repeat the issue you are reporting. Thanks in advance.
[26 Oct 2020 1:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Description: Hello, I am attempting to import CSV files that has a variable with leading 0s (i.e. 01556) using Import Wizard in MySQL Workbench, yet there is no varchar option for field type. I can't import these as text as they are also the PK so need to be numbers for joining purposes. Integer doesn't seem to work either as I get the following error message when setting field type to integer: - Row import failed with error: ("Out of range value for column 'SID' at row 1", 1264) How to repeat: Try importing a CSV utf-8 file via Import Wizard into MySQL Workbench to see field options available. Suggested fix: Include varchar option for field type in Import Wizard.