Special Charecters handling using BODS flat file
I have 2 sets of data one with no special charecters and one with Special Charecters in source. I have generated flat files(with UTF-8 code page bot hdata special charescters and no special chars) thruogh BODS in to a perticular path, when I am copying file from one path to another path file behaviour is changing it is saving as ANSI (it is only ith the file does not have special charecters, special charecters file if capoying with UTF-8 code page)
And also I have faced the special chareter file with jumbling of data.
Like : ID| Number |Name|Country
If observed above scenario, in th the 1st record country data concatenated with name.
I really appriciate, If any one help me to slove this issue.
Note: Special charecters are like: */„…ÂŸ etc and also multilanguage data