I'm creating dynamic website with Php and Mysql. So i need insert bangla language to Mysql database. How do i do this with php and mysql ?
Insert code:
$query = mysql_query("INSERT INTO news_post VALUES ('', '', '$subject',
'$img','$image_named_uniq','$message','$news_id','$cat_name','', '$poster', '$date' )");
Well, if i write English Language then its OK, But if i write Bangla Language then it's show Something like that == ভ াø ; 4;র ; ম& #2494; == Like Html entities...
Or any Idea that will better for me.
Shibbir.
check your encoding of data in your App as well as in DB
have a look at this
You must add these two lines just after selecting the database, i.e mysqli_connect() function.
mysqli_query($conn,'SET CHARACTER SET utf8'); mysqli_query($conn,"SET SESSION collation_connection ='utf8_general_ci'");