ANNOUNCEMENT: community.oracle.com is currently Read only due to planned upgrade until 28-Sep-2020 9:30 AM Pacific Time. Any changes made during Read only mode will be lost and will need to be re-entered when the application is back read/write.
I have a Visual Basic application that uses a mySQL database. The database is defined for the utf8mb4 characterset. The application uses version 5.3 unicode drivers for the connection. Within the application, I can insert Chinese characters correctly, however, when I insert Chinese characters using SQL within SQLDeveloper, the Chinese characters are questions marks. I tried setting the encoding within tools > preferences to unicode and UTF8 but this did not help. Any help on this will be greatly appreciated.