Focal Point
[CLOSED] reading from source to .ftm file

This topic can be found at:

October 18, 2018, 04:59 PM
[CLOSED] reading from source to .ftm file
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,

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