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
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 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.
Sept 7 : Save the changes and close toad application then start again.
Now Connect to the database...
Dear Ragavan ji,
ReplyDeleteI 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.