I'm importing values from a CSV into my wordpress MySQL database. CSV is generated via SSIS and encoded as UTF-8. Encoding of the website is set to UTF-8 in its header.

Checked values in the database, they seem to be imported correctly.


But when echoing the values on my website, Umlauts are displayed as ���

Interestingly, when looking at fields in other tables (not filled by myself manually), where Umlauts are displayed correctly, an ü-Umlaut looks like this: üc

I saw the database encoding was set to swedish and changed to UTF already, but it didn't work. Also checked for the table using show create table wp_bp_xprofile_data, which seems correct, too, charset is set to utf8.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.