Problems with Enconding Character - Oracle

0

Hello, I have a base oracle and when I make a select of a specific field the information that returns has accentuation, ex: "RECEPTION"

But when I save this information in a text file using the UTL_FILE.PUT_LINE (FIELD) the information in the file is thus "RECEPO"

The base is configured as:

nls_language = AMERICAN nls_territory = AMERICA CHARACTERSET = WE8MSWIN1252

I have tried to set the NLS_LANG from where I call the procedure to the same base format, but it did nothing.

export NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252

Any tips on how to do it so I can save the text as "RECEPTION" and not "RECEPO"?

Thank you

    
asked by anonymous 21.05.2018 / 22:10

0 answers