Bug #6012 set charset for LOAD DATA INFILE
Submitted: 11 Oct 2004 9:00 Modified: 3 Oct 2008 16:30
Reporter: Michael Kofler Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Charsets Severity:S4 (Feature request)
Version:4.1.5 OS:Any (-)
Assigned to: CPU Architecture:Any

[11 Oct 2004 9:00] Michael Kofler 
Description:
LOAD DATA INFILE misses an option to set the charset of the text file to be read

How to repeat:
import a text file with another encoding than the MySQL (connection) charset; non ASCII characters get interpreted wrong

Suggested fix:
add CHARSET option to LOAD DATA INFILE
[12 Oct 2004 10:22] MySQL Verification Team 
Hi,

Thank you for the report!
I've changed Severity to "Feature request". 
This is already in our TODO list, but this task has not high priority.
[4 Oct 2008 9:30] Konstantin Osipov 
This has been implemented in 5.0.

http://forge.mysql.com/worklog/task.php?id=993