SQL*Loader and UTF8 file - shifting data to the right
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))