Alex Lima

French accents character when using SQL*Plus

Published by

Alex Lima

on

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.

5 responses to “French accents character when using SQL*Plus”

  1. James Avatar
    James

    French accents character when using SQL*Plus

    Would you have a fix for OpenVMS?

    Like

    Reply
  2. Rachel Wang Avatar
    Rachel Wang

    It fixed my problem. Thank you so much.

    Like

    Reply
  3. Mr. Alphonse Avatar
    Mr. Alphonse

    merci!

    Like

    Reply
  4. patriko Avatar
    patriko

    thank you, in my file.sh , I juste add :

    export NLS_LANG=.AL32UTF8

    set NLS_LANG=.UTF8

    Like

    Reply
    1. vamsi Avatar
      vamsi

      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

      Like

      Reply

Leave a reply to Mr. Alphonse Cancel reply

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

Previous Post
Next Post

Alex Lima

About

Taking one day at a time.

Follow Us

Blog at WordPress.com.