This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Jun 7, 2013 6:55 PM by Sergiusz Wolicki (Oracle) RSS

Spool Brazilian characters to a file

967473 Newbie
Currently Being Moderated
Hi all,
Oracle version Oracle Database 11g Release 11.2.0.1.0 - 64bit Production running on CentOS Linux release 6.0 (Final), kernel 2.6.32-71.29.1.el6.x86_64.

I am having a hard time spooling a file and displaying special Brazilian characters, even though I can see them correctly in SQLDeveloper:
LEOPOLDO COUTO DE MAGALHÃES JÚNIOR

Spool:
LEOPOLDO COUTO DE MAGALH?ES JUNIOR

I've tried changing the NLS_LANG at the session level, but that cannot be done. I don't want to change the default language of my DB, but really need these characters to display correctly in a file.

Any suggestions would be greatly appreciated.
Thanks!

Edited by: 964470 on Jun 6, 2013 7:27 AM
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points