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 Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S4 (Feature request)
Version:5.0 OS:Any
Assigned to: CPU Architecture:Any
Triage: Triaged: D5 (Feature request)

[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] Miguel Solorzano
Thank you for the bug report.