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.