1 2 Previous Next 18 Replies Latest reply: Jul 26, 2012 12:41 AM by Osama_Mustafa Go to original post RSS
      • 15. Re: How to insert Arabic words in database
        891682
        Actually There are 2 language showing in language bar first is English and second is Arabic .I have change the language bar first Englsih then its Oracle connected now.
        in
        sql>SHOW parameter NLS%

        SQL> SHOW parameter NLS%

        NAME TYPE VALUE
        ------------------------------------ ----------- --------------
        nls_calendar string
        nls_comp string
        nls_currency string
        nls_date_format string
        nls_date_language string
        nls_dual_currency string
        nls_iso_currency string
        nls_language                         string      AMERICAN
        nls_length_semantics string BYTE
        nls_nchar_conv_excp string FALSE
        nls_numeric_characters string

        NAME TYPE VALUE
        ------------------------------------ ----------- --------------
        nls_sort string
        nls_territory string AMERICA
        nls_time_format string
        nls_timestamp_format string
        nls_timestamp_tz_format string
        nls_time_tz_format string
        SQL>
        Still showing American...
        Plz help me..

        Thanks
        Anup
        • 16. Re: How to insert Arabic words in database
          891682
          but to maintain two instance in running project will increase the development efforts for sync the same

          Edited by: 888679 on Jul 25, 2012 4:55 AM
          • 17. Re: How to insert Arabic words in database
            Sergiusz Wolicki-Oracle
            1) Do not use SQL*Plus with Arabic. Use SQL Developer.
            2) Do not worry about NLS_LANGUAGE in SHOW PARAMETER. NLS_LANGUAGE does not matter for the storage of Arabic characters.
            3) If you have connection errors, please, paste them here and do not just tell you have them ;-)

            -- Sergiusz
            • 18. Re: How to insert Arabic words in database
              Osama_Mustafa
              Any Updates ?
              1 2 Previous Next