After Inserting Arabic Text In Data Base Using UiPath, While Retrieving The Data The Values Appear As "??????????"

News Knowledge Base
, ,
1

How to insert Arabic text in data base using UiPath ?

Note: For Arabic text, proper character encoding needs to be set in DB.

  1. First check the NLS_CHARACTERSET parameter of the database using the SQL*PLUS command :-
  • select * from v$nls_parameters where parameter = 'NLS_CHARACTERSET';

The result of the above query should be as below,

PARAMETER
 VALUE
NLS_CHARACTERSET
 AR8MSWIN1256

If it is not, then change the value of this parameter using below steps,

  1. Hit WINDOWS KEY + r on the keyboard
  2. Write: SQLPLUS sys as sysdba
  3. Press Enter then enter the password or just hit another Enter
  • Issue the following commands,
    • SHUTDOWN IMMEDIATE
    • STARTUP RESTRICT
    • ALTER DATABASE CHARACTER SET INTERNAL_USE AR8MSWIN1256;
    • ALTER DATABASE CHARACTER SET AR8MSWIN1256;
    • SHUTDOWN IMMEDIATE
    • STARTUP
  1. Change the value of the NLS_LANG registry string into AMERICAN_AMERICA.AR8MSWIN1256
  2. if the operating system is a flavor of UNIX use
  • AR8ISO8859P6 instead of AR8MSWIN1256 as the value of NLS_CHARACTERSET
  1. Do not use National datatypes (i.e NVARCHAR, NTEXT, or NCLOB ) in the database unless other languages other than (Arabic and English) are going to be used inside the database
  2. AR8MSWIN1256 character set is sufficient for mixing Arabic and English inside the same field .


Read more on,