I have a database that contains Spanish words in it. It contains words like sueño which have "special characters" in them. The MySQL database collation is set to utf-8-general-ci which supports foreign characters, so the database should be fine.
I have a python script that I run in the bash shell and it returns all words in the database, including the word sueño. The problem is that the bash shell doesn't display the word "sueño" properly. The n (with the tilde over it) is garbled when displayed in the bash shell. All other English words with no special characters are displayed properly.
Is there any way to enable foreign character (special character) support in the bash shell?