Hi,
In the invoice description field in the database, we are getting this character (¿) which is causing issues in record layout when we generate a fixed length text file using sql plus script. The record is getting split into 2-3 lines instead of one line. Below please find examples how the description looks in each case (our users copy the description from an online catalog).
In the Oracle forms, the description comes with squares as shown below:
Lexmark C5340CX Cyan Toner�������
when the record is saved in the Oracle database, the same description comes with inverted question marks as shown below:
Lexmark C5340CX Cyan Toner¿¿¿¿¿¿¿
when we generate the fixed length text file using sql plus, the same description comes with some junk characters as shown below:
Lexmark C5340CX Cyan Toner����
I tried both replace and translate commands, but it's of no use. I tried ascii character chr(191) for the inverted question mark, but its not working.
Please let me know if any of you came across this issue and how you resolved this? I really appreciate any feedback on this.
regards,
Jagan