Writing Arabic characters using UTL_FILE

Case: Writing queried Arabic character into a file through Oracle 9i

 

 

Our application uses Oracle Forms 9i and Oracle 9i.

We are able to save and retrieve Arabic character through the form. But the data stored in the database shows ‘¿¿¿¿¿ ¿¿¿¿¿'.

This is because the database nls_characterset is UTF8.

 

We are able to query and write these Arabic characters from the form, into files.

We use the following to write from the form. (Convert characterset before writing)

CLIENT_TEXT_IO.FOPEN(pi_filename,'W','AR8MSWIN1256');

CLIENT_TEXT_IO.PUT(); 

CLIENT_TEXT_IO.FCLOSE();

 

The file created does contain the Arabic characters.