My Oracle Support Banner

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.