MySQL Bugs: #6012: set charset for LOAD DATA INFILE

Bug #6012	set charset for LOAD DATA INFILE
Submitted:	11 Oct 2004 11:00	Modified:	3 Oct 2008 18:30
Reporter:	Michael Kofler
Status:	Closed
Category:	Server: Charsets	Severity:	S4 (Feature request)
Version:	4.1.5	OS:	Any (-)
Assigned to:		Target Version:
Triage:	Triaged: D5 (Feature request)

View
Add Comment
Files
Developer
Edit Submission
View Progress Log

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

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.

This has been implemented in 5.0.

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