OraFAQ Forum: Forms » Creating a UTF-8 text file from Oracle Forms 6i

Home » Developer & Programmer » Forms » Creating a UTF-8 text file from Oracle Forms 6i (Oracle forms 6i, Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Creating a UTF-8 text file from Oracle Forms 6i [message #610164]

Tue, 18 March 2014 04:17

sarfraz_attari
Messages: 123
Registered: July 2005

Senior Member

Dear All

I need to generate a text file from the data available in database.

We can create a text file in ANSI format but we need to create a text file in UTF-8 format.

We tried following commands to convert the text from ansi to utf-8 but arabic characters are appearing as junk

linebuf:='DTL'||V_CIVILID||v_EMP_NAME_AR||v_EMP_AC_NO||ltrim(V_CR_AMT)||V_DB_AC_NO||' '||V_BEN_BANK||V_EMP_CODE||V_EMP_NAME_EN||' ';
select convert(linebuf,'utf8','us7ascii') into linebuf1 from dual ;

Text_IO.put_Line(OUT_file,linebuf1);

Can anyone help me

Thanks and regards

Sarfarazh Attari

Report message to a moderator