用于中文文本的php utf-8编码

Question

I am doing migration to generate SQL from one DB to another.

I am trying to get the output

But when I did a mb_convert_encoding("Mr.Wang (王老板)", 'UTF-8', 'Windows-1252')

I have the output as

I have those two extra "box". Any idea what am I doing wrong?

phpMyAdmin is able to export my old database containing chinese text in correct format, how do it do that in script?

*updated the images to better show my view

Answer 1

Have you tried setting the header in the script to UTF8? What I normally use is the following:

header('Content-Type: text/html; charset=utf-8');

That has worked for me so far for German characters & some Arabic & Japanese etc.