$FILE_READER: TPT19134 !ERROR! Fatal data error processing file 'input_import.csv'. Delimited Data Parsing error: Invalid multi-byte character in row 221, col 1.
 freetext VARCHAR(4000) CHARACTER SET UNICODE NOT CASESPECIFIC
 tdload -f input_import.csv -u xxxxx -p xxxx -c UTF8 -h dwhprod01 -t input_import -d "|" --TargetWorkingDatabase db_prod_one_input
I'm facing an issue with tdload and multibyte problems. I want to load a free text field from users, where they sometimes input emoticons.
The error I get is 
My field in teradata is 
Import command 
Teradata v. 14.0
What I've already tried:
Any help and idea would be appreciated. Thank you!
UTF-8 (hex) 0xF0 0x9F 0x91 0x8D (f09f918d)
UTF-8 (binary) 11110000:10011111:10010001:10001101
It was the character above, also called "thumbs up". Just google for "unicode character thumbs up".
As a workaround I created a script that removes all characters above latin-1. But it would be nicer to just import all the data.