如何在数据库中使用拉丁校对和utf8校对表插入utf-8格式

Question

how to insert utf-8 format in database with latin collation and table with utf8 collation?!

I want to insert to some of wordpress database tables from my own php file , but it's not working, if I change the databsae collation into utf8_general_ci it's working , I don't want to change the database collation , wordpress it self working with that and it doesn't have any problem, سلام -> ؟؟؟؟

Answer 1

You can try

$mysqli->set_charset("utf8");

before you do any inserts.