This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Jul 25, 2012 10:41 PM by Osama_Mustafa Go to original post RSS
  • 15. Re: How to insert Arabic words in database
    891682 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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) Expert
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    Any Updates ?
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points