WL#993: LOAD DATA INFILE and character sets
Affects: Server-5.0
—
Status: Complete
Extend LOAD DATA INFILE to support specifying character sets for the whole file and for field level. PeterG> this new task should (I believe) be associated with a SAP DB PeterG> task, since SAP DB Loader allows specification PeterG> of the file character set. peterg> LOAD DATA ... INTO table-name CHARACTER SET x ... bar> Tobias proposes this syntax: bar> LOAD DATA INFILE 'file' INTO TABLE t1 ... USING charset bar> which looks nice. bar> We can support it together with SAP style syntax. Note: cancelling this task; the functionality exists using different syntax, per the MySQL Reference Manual, which says (at http://dev.mysql.com/doc/refman/5.0/en/load-data.html): "13.2.5. LOAD DATA INFILE Syntax ... The character set indicated by the character_set_database system variable is used to interpret the information in the file. SET NAMES and the setting of character_set_client do not affect interpretation of input." -- Trudy Pelzer, 2005-12-13
Copyright (c) 2000, 2025, Oracle Corporation and/or its affiliates. All rights reserved.