I am reading txt file from source and storing in .ftm file before bulk loading into my database. The source file has a french character that is not reflected in my .ftm file instead it is giving a invalid character. Why is the french character changed?This message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 8 Windows, All Outputs
October 19, 2018, 07:54 AM
It is an encoding issue. If the characters are being replaced by a "?" then it is a single byte file. You can add CODEPAGE=137 to the .mas and that should solve your problem. If he characters are being replaced by 2 characters, then you have a multi-byte file. Add CODEPAGE=65001 if that is the case.
"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott