Database Utilities (MOSC)

MOSC Banner

SQL*Loader and UTF8 file - shifting data to the right

edited Oct 8, 2009 3:09AM in Database Utilities (MOSC) 3 commentsAnswered
Hello!

Got a 10.2.0.4 database using AL32UTF8 setup on a linux. Having issues loading a text file in UTF8 format into the database, where columns are shifted to the right where there are UTF8 characters. Feeling lost... maybe someone in here have been in the same situation and know what I am missing?

Example, setting up this table on the server:

create table loader_test (
 product varchar2(10),
 description varchar2(10),
 field1 varchar2(1),
 field2 varchar2(1),
 field3 varchar2(1)
);

Control file to the SQL*Loader (version 10.2.0.4, being loaded from a Windows machine, but the same issue when loaded from linux):

OPTIONS (skip=0, errors=9999999, silent=(errors))

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center