Using BCP to load data from a ASCII FIle generated by UTL_FILE Imports the Data Incorrectly
(Doc ID 838347.1)
Last updated on APRIL 21, 2022
Applies to:
PL/SQL - Version 9.2.0.1 to 11.1.0.7 [Release 9.2 to 11.1]Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)
Microsoft Windows Server 2003 (64-bit AMD64 and Intel EM64T)Microsoft Windows (32-bit)
Symptoms
Using the SQL Server Bulk Load Copy Utility (BCP) to import data from a file generated with
UTL_FILE containing extended characters on windows such as é fails to import the special characters properly.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |