I often need to load the data of Excel or CSV files into the Oracle Database.
Ever got those annoying question marks when you try to load the data? or instead of question marks you just get empty blanks when the file is using special characters? Here's an example:
Another way is to open Terminal and use the iconv command line tool to convert the file
iconv -t UTF8 -f MACROMAN < file.csv > file-utf8.csv