Mysql characters

Question

I am with a registration system in one of the fields I insert an html code:

<iframe src="https://www.facebook.com/plugins/video.php?href=https%3A%2F%2Fwww.facebook.com%2FLelegameplayy%2Fvideos%2F513067752776685%2F&show_text=0&width=560" width="560" height="315" style="border:none;overflow:hidden" scrolling="no" frameborder="0" allowTransparency="true" allowFullScreen="true"></iframe>

But in the database it looks like this:

<iframe src=&#34;https://www.facebook.com/plugins/video.php?href=https%3A%2F%2Fwww.facebook.com%2FLelegameplayy%2Fvideos%2F513067752776685%2F&show_text=0&width=560&#34; width=&#34;560&#34; height=&#34;315&#34; style=&#34;border:none;overflow:hidden&#34; scrolling=&#34;no&#34; frameborder=&#34;0&#34; allowTransparency=&#34;true&#34; allowFullScreen=&#34;true&#34;>

excluding all accentuation

Structure of the database

Answer 1

Matthew, put the CHARSET and the COLLATE of your tables (or the entire database) the same as your PHP is using and both are accentuated compatible.
For example, in the database your tables should be created like this:

CREATE TABLE IF NOT EXISTS `TAB1` (
  `id` int(6) unsigned NOT NULL,
  `content` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8 COLLATE = utf8_general_ci;

And on your PHP pages put the tag below inside the <header> of HTML.

<meta charset="UTF-8">