How to read Portuguese data?
I’m developing a Python API using FastAPI to read a CSV file containing a list of medicines approved by the Brazilian government. The CSV file is in Portuguese, which includes special characters such as á, é, ã, etc. However, I’m encountering an issue where Python doesn’t handle these characters correctly by default. This leads to incorrect string comparisons between hardcoded strings and those read from the CSV file.