SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Foreign characters to be inserted with sqlplus

$a!Oct 12 2017 — edited Oct 16 2017

Hi All,

I have .sql script where netherlands and portugese content has to be inserted into a table

values like Configuração etc. When i am using sql developer to run the script, the data is reflecting correctly. But when doing through sqlplus, it is getting corrupted.

I have tried setting by nls_lang at cmd prompt level to set NLS_LANG=AMERICAN_AMERICA.AL32UTF8 and also DUTCH_THE NETHERLANDS.WE8MSWIN1252(To check if atleast netherlands content is coming fine), but in vain

Is there a single character set that helps for all the different countries content(at least the major ones).?

Kindly help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 13 2017

Added on Oct 12 2017

24 comments

5,899 views