1 2 Previous Next 16 Replies Latest reply: Jun 7, 2013 8:55 PM by Sergiusz Wolicki-Oracle RSS

    Spool Brazilian characters to a file

    967473
      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