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