French accents character when using SQL*Plus

For SQL*Plus to process french accents characters when using SQL*Plus, you would need to set NLS_LANG

On Windows
set NLS_LANG=.AL32UTF8
set NLS_LANG=.UTF8
On Unix (ksh)
export NLS_LANG=.AL32UTF8
set NLS_LANG=.UTF8

Now when you start SQLPlus from Unix or Windows it will keep the accents on the french characters.

Advertisements

5 comments

    • HI Team,

      I am using in french characters in .sql file, it is getting compilation errors of french characters.

      Could you please let how compile

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.