Special Charecters handling using BODS flat file

[Former Member]

Hi All,

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

          1 |103|TejaIndia

          2|104|Vini|India

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

Thanks,

Lavanya

[former_member205887]

Post sample data from your source file, if possible attach it to the post and let us know the expected result.