4 Replies Latest reply on Nov 12, 2019 5:38 PM by Sergiusz Wolicki-Oracle

    Updating table column with arabic text

    Shareef Khaleel

      Dear All,

       

      We are using db 11.1.0.2; OS: Oracle Linux 7.3

       

      For business needs we have to update database table records from other data source stored in text file; for that we created directory object and external table;

       

      We are doing this under Linux;

       

      One of columns in external table are in Arabic, we can read records from this external table file; as you can see in attached image (Although we have to read Arabic from left to right):

      1.png

       

      And we can read Arabic columns from database table by setting NLS_LANG=.AL32UTF8 first; then query records; also have to read Arabic columns from left to right.

       

      Any how.

       

      When we update database table (merge external file records into database table) records updated; but columns with Arabic values stored in different characters:

       

      2-Reading.png

       

       

      We don't have any issue in Arabic in Windows OS; we can insert, update, select.... Arabic data with no issue at all.

       

      Out put of:

       

      SELECT *

      from NLS_DATABASE_PARAMETERS

      WHERE PARAMETER IN ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET')

       

      NLS_CHARACTERSET                        AR8ISO8859P6

      NLS_NCHAR_CHARACTERSET          AL16UTF16

       

      external text file format [  file -i Coordinates.dat  ]is:

      text/plain; charset=utf-8

       

       

       

      Can you please help me in this issue.

       

       

      Thanks and Regards,

      Shareef