Hi, How can i set the character set for an Input CAT (txt) file. It seems it is not possible and when writing to a database (UTF-8) the scandic characters get messed up. Shold FME be able to recognize the character set from the file?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
After reading the file, can you then use a TextDecoder or TextEncoder to properly convert to UTF-8?
Another option woule be to use the Textfile reader instead of the CAT - reader, and specify the Character encoding. And afterwards one SubstringExtractor for each column to get. Does not work with Generic Readers - however if you always have the same formatted input-file it will work.
Also you can request safe to include the Character Encoding option on ALL NON-BINARY files READ and WRITE, not sure if that is already a PR.