8 Replies Latest reply on Oct 30, 2014 12:21 PM by M Padmanabhan

    Arabic Data Loaded through sql Loader

    M Padmanabhan

      Hi

       

      The Excel data is imported through Sql Loader. The Arabic language is not coming property.

       

      Please help me regarding this

       

      Regards

      M.Padmanabhan

        • 1. Re: Arabic Data Loaded through sql Loader
          thatJeffSmith-Oracle

          How are you getting data from Excel into SQL Loader?

           

          Are the issues with the load or with display in SQL Developer?

          • 2. Re: Arabic Data Loaded through sql Loader
            M Padmanabhan

            Hi

             

            Thanks for your communication.

             

            How are you getting data from Excel into SQL Loader?


            Yes, The import data from Excel File


            Are the issues with the load or with display in SQL Developer?


            After the loaded the data successfully, the arabic column some extra character is showing like this è


            Ex:

            رèج انخضراء ننهثنجات  ==> è  


            • 3. Re: Arabic Data Loaded through sql Loader
              thatJeffSmith-Oracle

              If the Arabic characters are showing at all in SQL Developer, then I think your problem might be with the source data or your SQL*Loader session.

              • 4. Re: Arabic Data Loaded through sql Loader
                M Padmanabhan

                How to solve this issue.. Help me.

                • 5. Re: Arabic Data Loaded through sql Loader
                  How are you getting data from Excel into SQL Loader?

                   

                  Yes, The import data from Excel File

                   

                  Sorry - that isn't clear.

                   

                  Are you using Sql loader to load the data? Or are you using sql developer?

                   

                  Tell us the EXACT steps you are using to do the load.

                  Are the issues with the load or with display in SQL Developer?


                  After the loaded the data successfully, the arabic column some extra character is showing like this è

                  How did you determine that the data was loaded 'successfully'?

                   

                  What database (name and full version) are you using?

                   

                  What is the database character set?

                   

                  What is the client character set?

                   

                  What version of sql loader are you using?

                   

                  What version of sql developer are you using?

                   

                   

                  • 6. Re: Arabic Data Loaded through sql Loader
                    M Padmanabhan

                    Thanks for your reply

                     

                    Now i used the following steps.

                     

                    Steps:1

                     

                    1. The loaded excel data through Sql Developer version 4.0.3.16

                    2. The Sql Developer has shown the successfully.

                     

                      Note: Sql Developer data has shown مؤسسة فاطمة بنت سهيل علي الكثيري للتجارة

                               Sql Plus,Toad,PlSql Developer has shown هؤسسة لا×هة بوت سçêن ظنê انمثêرê ننتجارة

                     

                    My requirement

                     

                    This table data , i will copy to different countries.

                     

                    So i will use the Dos Prompt

                     

                    1. First i will the set nlslang = ARABIC_EGYPT.AR8MSWIN1256 or set nlslang = AMERICAN_AMERICA.AR8IS08859P6

                    2. i will use the  exp command = exp mpn/mpn@oracle9   table = (test) file=test.dmp log=test.log.

                     

                    This test.dmp file, i will move to different countries through team viewer.

                     

                    1. First i will the set nlslang = ARABIC_EGYPT.AR8MSWIN1256 or set nlslang = AMERICAN_AMERICA.AR8IS08859P6

                    2. i will use the  imp command = imp mpn/mpn@oracle9   table = (test) file=test.dmp log=test.log.

                     

                    The Client will see the data in Oracle Forms 6i

                     

                    Forms Version:

                     

                    Forms [32 Bit] Version 6.0.8.20.1 (Production)

                    Oracle Toolkit Version 6.0.8.21.0 (Production)

                    PL/SQL Version 8.0.6.3.0 (Production)

                    Oracle Procedure Builder V6.0.8.17.0 Build #863 - Production

                    PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production)

                    Oracle Query Builder 6.0.7.1.0 - Production

                    Oracle Virtual Graphics System Version 6.0.5.38.0 (Production)

                    Oracle Tools GUI Utilities Version 6.0.8.20.1 (Production)

                    Oracle Multimedia Version 6.0.8.20.0 (Production)

                    Oracle Tools Integration Version 6.0.8.18.0 (Production)

                    Oracle Tools Common Area Version 6.0.8.18.0

                    Oracle CORE Version 4.0.6.0.0 - Production

                     

                    What database (name and full version) are you using?

                    Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production

                    PL/SQL Release 9.2.0.1.0 - Production

                    CORE    9.2.0.1.0       Production

                    TNS for Solaris: Version 9.2.0.1.0 - Production

                    NLSRTL Version 9.2.0.1.0 - Production

                     

                     

                    SELECT * FROM NLS_SESSION_PARAMETERS;

                     

                      

                    NLS_LANGUAGE            AMERICAN                              
                    NLS_TERRITORY           AMERICA                               
                    NLS_CURRENCY            $                                     
                    NLS_ISO_CURRENCY        AMERICA                               
                    NLS_NUMERIC_CHARACTERS  .,                                    
                    NLS_CALENDAR            GREGORIAN                             
                    NLS_DATE_FORMAT         DD-MON-YY                             
                    NLS_DATE_LANGUAGE       AMERICAN                              
                    NLS_SORT                BINARY                                
                    NLS_TIME_FORMAT         HH.MI.SSXFF AM                        
                    NLS_TIMESTAMP_FORMAT    DD-MON-RR HH.MI.SSXFF AM              
                    NLS_TIME_TZ_FORMAT      HH.MI.SSXFF AM TZR                    
                    NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR          
                    NLS_DUAL_CURRENCY       $                                     
                    NLS_COMP                BINARY                                
                    NLS_LENGTH_SEMANTICS    BYTE                                  
                    NLS_NCHAR_CONV_EXCP    

                    FALSE                                 

                     

                     

                     

                       SELECT * FROM NLS_DATABASE_PARAMETERS;

                    NLS_LANGUAGE              AMERICAN                      
                    NLS_TERRITORY             AMERICA                       
                    NLS_CURRENCY              $                             
                    NLS_ISO_CURRENCY          AMERICA                       
                    NLS_NUMERIC_CHARACTERS    .,                            
                    NLS_CHARACTERSET          AR8ISO8859P6                  
                    NLS_CALENDAR              GREGORIAN                     
                    NLS_DATE_FORMAT           DD-MON-RR                     
                    NLS_DATE_LANGUAGE         AMERICAN                      
                    NLS_SORT                  BINARY                        
                    NLS_TIME_FORMAT           HH.MI.SSXFF AM                
                    NLS_TIMESTAMP_FORMAT      DD-MON-RR HH.MI.SSXFF AM      
                    NLS_TIME_TZ_FORMAT        HH.MI.SSXFF AM TZR            
                    NLS_TIMESTAMP_TZ_FORMAT   DD-MON-RR HH.MI.SSXFF AM TZR  
                    NLS_DUAL_CURRENCY         $                             
                    NLS_COMP                  BINARY                        
                    NLS_LENGTH_SEMANTICS      BYTE                          
                    NLS_NCHAR_CONV_EXCP       FALSE                         
                    NLS_NCHAR_CHARACTERSET    AL16UTF16                     
                    NLS_RDBMS_VERSION         9.2.0.1.0                     

                     

                    Sql Developer Version: Sql Developer version 4.0.3.16

                     

                     

                    Help me regarding this...

                    • 7. Re: Arabic Data Loaded through sql Loader
                      thatJeffSmith-Oracle

                      Ok, first you said you used SQL Loader to load the data, but you acutally used SQL Developer.

                       

                      Then you say the data looks correct in SQL Developer - is that when you're previewing it in the import data wizard, or after it's been loaded?

                       

                      If it's after it's been loaded, then you probably have a NLS/Local machine language support issue.

                       

                      SQL Developer is a native Unicode application and doesn't require any special setup on the client to correctly display the data in your database.

                       

                      Those other tools your using, do.

                       

                      If it looks good on SQL Developer, then you need to go to a different forum for help with those other technologies.