<div>
You cannot save images in UTF8 you have to use UTF8mb4 .<br />
<a href="https://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html" rel="ugc">https://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html</a><br />
<br />
Change the table collation with something like<br />
<br />
ALTER TABLE Tablename CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin
</div>


You cannot save images in UTF8 you have to use UTF8mb4 .
https://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html [https://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html]

Change the table collation with something like

ALTER TABLE Tablename CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin

Developer & Coffee Roaster

Scott Fell

<div>
let me check this and what will be character set of entire database?
</div>


let me check this and what will be character set of entire database?

<div>
You can also set a charset on a table basis or single column basis.
</div>


You can also set a charset on a table basis or single column basis.

<div>
The character set will be UTF8 with support for BMP files.
</div>


The character set will be UTF8 with support for BMP files.

<div>
<div class="content wysiwyg-content">
I have json which contains emoji emotions. I am trying to save it in DB but it cannot be inserted. My Db is UTF8 and also my collation is utf8. <br />
Need help
</div>
</div>


I have json which contains emoji emotions. I am trying to save it in DB but it cannot be inserted. My Db is UTF8 and also my collation is utf8. 
Need help

PHP to mysqli db insertion issue

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

JavaScript Object Notation, or JSON, is human-readable text used when transmitting data objects consisting of attribute:value pairs between a server and a web application as an alternative to XML. JSON, while it is originally derived from JavaScript, is a language-independent data format. Code for parsing and generating JSON data is available in many programming languages.