encodingspecial-characterspeoplesoftfile-encodingssqr

Unable to process file in SQR process due to special character


I am currently working in SQR process, and had encountered an issue during file processing as it results to error due to special character, slanted apostrophe (’). It is a flat file saved as UTF-8. I tried changing it as ANSI and worked well, but how do I make my code work without changing the encoding?


Solution

  • On your open statement, try adding:

    ENCODING=UTF-8