Represent a  in Oracle 1

[jrennatc3]

We currently are using RightFax to send text documents with some embedded tags out to our customers. I have been tasked with taking the UNIX scripts and converting them to Oracle using UTL_FILE to write out the documents. I ran into an issue where Right fax uses a  in one of the embedded tags to change the orientation to landscape. I cannot get Oracle to place this character in the text document. When I paste this character into my procedure, it gets converted to a "." When I tried to use chr(27) I still get a "." in the UTL_FILE output. Anyone have any clue how to make Oracle write this character?

 

[Beilstwh]

Are you sure, then you print out or view a file containing binary, most applications will replace the unprintable binary with a period. have you used a binary viewer to display the file?

Bill
Oracle DBA/Developer
New York State, USA

 

[jrennatc3]

You got it! I hadn't checked my FTP program, and it was set to ASCII. I changed to binary and it was fine. Thank you so much.