Arabic data in txt file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Arabic data in txt file

  1. #1
    Join Date
    Feb 2004
    Location
    India
    Posts
    18

    Arabic data in txt file

    Hi everyone,
    I have an oracle 9i database on windows xp running which has a table containing data in arabic.The characterset supporting the arabic language has been already set correctly.

    I need to spool the data of that table it in a text or csv file ....
    Any ideas on that ....

    Normal spooling gives the result in '????'

    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    can the client actually process the arabic characters?

  3. #3
    Join Date
    Feb 2004
    Location
    India
    Posts
    18
    Yes

    Select columnname from tablename where.....

    gives the correct output and in Arabic.

    I think when we save it in a text file it gets saved in ANSI encoding if i could save it in Unicode encoding then i could get the spooled data in arabic.

    as we write spool c:\ar.txt
    it opens a file when spool off it saves the data in Ansi encoding is there any way to specify the encoding
    Last edited by kausik_m123; 10-19-2006 at 08:12 AM.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    i mean notepad / windows, does it know how to deal with the characters

  5. #5
    Join Date
    Feb 2004
    Location
    India
    Posts
    18
    Quote Originally Posted by davey23uk
    i mean notepad / windows, does it know how to deal with the characters

    I guess if the notepad file is saved in Unicode

Posting Permissions

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



Click Here to Expand Forum to Full Width