How to handle Special Characters in Upload wizard in Oracle APEX from CSV file:
é è à ù ç ñ ö ë í á ó
Also, I want to do Transformation of these special char to Alpha chars.
When I upload Excel through CSV, it shows like below:
When I do copy/paste it shows like below:
What is the file encoding attribute ? When I pick US-ASCII then the characters are not recognized and it shows the characters as �. But when I take a multibyte character eg Unicode UTF-8 it works fine