Bug #29712 mysqlimport lacks option for CHARACTER SET clause in LOAD DATA

• Submitted: 11 Jul 2007 6:23
• Modified: 11 Jul 2007 13:01
• Reporter: Alexander Keremidarski
• Status: Verified
• Category: MySQL Server: Command-line Clients
• Severity: S4 (Feature request)
• Version: 5.0
• OS: Any
• CPU Architecture: Any

[11 Jul 2007 6:23] Alexander Keremidarski

Description:
In 5.0.38 [CHARACTER SET charset_name] clause was introduced to LOAD DATA STATEMENT to make it possible importing data with character set different than  character_set_database

mysqlimport currently is not aware of this and only sends SET @@character_set_database=binary;

Proposal: Add new option to mysqlimport

How to repeat:
mysqlimport --help

Observe lack of option to set character set for LOAD DATA explicitly

Suggested fix:
Add new option to mysqlimport
--character-set=name

which will be used as

LOAD DATA INFILE 'file_name' INTO TABLE City CHARACTER SET 'name' ...;

[11 Jul 2007 13:01] MySQL Verification Team

Thank you for the bug report.