Thursday 18 May 2017

How to change Language To Arabic in Toad Oracle

Step 1: Check what NLS_LANGUAGE is being used in your database.

SELECT    (SELECT VALUE
             FROM nls_database_parameters
            WHERE parameter = 'NLS_LANGUAGE')
       || '_'
       || (SELECT VALUE
             FROM nls_database_parameters
            WHERE parameter = 'NLS_TERRITORY')
       || '.'
       || (SELECT VALUE
             FROM nls_database_parameters
            WHERE parameter = 'NLS_CHARACTERSET') LANGUAGE
  FROM DUAL



Step 2: Change the NLS _ LANGUAGE in Toad to the same.
Step 3: Open Toad
Step 4: Click on the button as shown below



Step 5 : Click on the current  NLS_LANGUAGE
Sept 6 : Change it according to the database.
Sept 7 : Save the changes and close toad application then start again.
 Now Connect to the database...

1 comment:

  1. Dear Ragavan ji,
    I have a server windows 2019 and oracle 11g is installed in it. One of the database table is having a field name of type nvarchar2 having english and Arabic data. When I am accessing this data from sql developer on the server it is giving proper text. But when I am accessing from client machine (Windows 10 with Oracle 11g client) is showing Arabic text as ????.

    The real problem is that I have a software called VizPilot in which I can use vbscript on the form. I need to get oracle data using vbscript into this form to populate different controls.
    Please help me.

    ReplyDelete