Database set up as Non-Unicode; "hidden" characters are being saved to Voucher DISTRIB_LINE descrs
A vendor is unable to process a file we are sending them due to "hidden" characters in the file. The interfaced file is generated by an SQR. If you look at the DESCR online, via SQL Select from the database, or in the interfaced file in Notepad++, you don't see them. However, if you change the encoding to ANSI then you see them. The vendor flags them and therefore cannot process our file.
Does anyone have any suggestions on how to prevent these on the data entry? We believe a users is copying and pasting from a PDF document into the data entry page.