Cannot display unicode when exporting to excel
Permalink
So far I have a website that can perfectly display Korean characters fine. MySQL DB has been using utf8_unicode_ci.
Guests and registered users can input unicode to the forms and the characters show up on the dashboard just fine. However the trouble begins when trying to export form submissions into excel. The characters look like á, í, ő, ű rather than Korean. In the past, the export went fine where the chars displayed right, but that was before we moved the site from a dev subdirectory to the root. The forms created before the move have the export function working right, and still do, but any forms created AFTER the move don't.
Any ideas on this?
Guests and registered users can input unicode to the forms and the characters show up on the dashboard just fine. However the trouble begins when trying to export form submissions into excel. The characters look like á, í, ő, ű rather than Korean. In the past, the export went fine where the chars displayed right, but that was before we moved the site from a dev subdirectory to the root. The forms created before the move have the export function working right, and still do, but any forms created AFTER the move don't.
Any ideas on this?
