Link to home
Create AccountLog 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
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Jay Redd
Jay Redd

ASKER

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