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.
Jay ReddAsked:
Who is Participating?
DavidConnect With a Mentor Senior Oracle Database AdministratorCommented:
First guess, you can stop it by switching your client's default character set to the one used to build the extracted file.  Secondly, switch to a more universal set.  See in particular the case 3 example from: .
Jay ReddAuthor Commented:
WE8ISO8859P1 seemed to do the trick. it inserted it correctly. Thanks!!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.