The Avro specification requires that character strings be stored as UTF-8 encoded character data. The database does not support UTF-8 on the server side, but stores Avro character strings as such. When exporting a JSON-encoded Avro value, the Teradata UNICODE character set is used.
CSV values are stored in the same character set that was specified for the DATASET value.