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
|
|
|
|