Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009
    Posts
    17

    Question Unanswered: NLS setting in Oracle 10g database

    Hi All,

    I want to use Farsi language, while creating database i have selected the charterset as UTF8.
    Now am able to retrieve data in Farsi language. And i also want to use Arabic calendar instead of GREGORIAN,
    for that i have used the following settings

    alter session set nls_calendar = 'arabic hijrah';
    select to_char(sysdate,'day dd month yyyy','nls_calendar=''arabic hijrah''') from dual ;

    TO_CHAR(SYSDATE,'DAYDDMONTHYYY
    -------------------------------
    wednesday 27

    but am getting the out put like this?

    is the procedure what i used correct? if its wrong, pl guide me.

    Thanks in Advance,
    Lucky.

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    did you set the local workstation to farsi. see the link.

    Contents
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Jun 2009
    Posts
    17

    Question

    yes i have changed in the registry, and set the local language to farsi.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •