"Write CSV" activity supports almost all type of encodings. If no encoding type is specified, the activity will search for the file's Byte Order Marks to detect the encoding. But sometimes the activity is not able to automatically detect the code and shows validation error. Why the inconsistency?
A character encoding tells the computer how to interpret raw zeroes and ones into real characters. It usually does this by pairing numbers with characters. Words and sentences in text are created from characters and these characters are grouped into a character set. There are many different types of character encodings floating around at present, but the ones we deal most frequently with are ASCII, 8-bit encodings, and Unicode-based encodings.
"Write CSV" activity supports almost all type of encodings. The complete list of encodings supported by "Write CSV" activity is provided in the below link: