Link to home
Start Free TrialLog in
Avatar of Jay Redd
Jay Redd

asked on

Funky Characters in SQL Loader

Hi folks
so I use SQL Developer's "Loader" format to export a big DB into flat files (LDR). However, I noticed that when reinserting them via SQL Loader,

Rodríguez (notice the accented "i") becomes Rodr¿¿guez.

Is there a way to stop this from happening? The files are generated and inserted in SUSE Linux.
ASKER CERTIFIED SOLUTION
Avatar of David VanZandt
David VanZandt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jay Redd
Jay Redd

ASKER

WE8ISO8859P1 seemed to do the trick. it inserted it correctly. Thanks!!