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
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
|Powered by Social Strata|