Insert Euro and Dollar symbol to a column in mysql
<p>I have 2 rows which looks like this.
<a href="https://i.stack.imgur.com/JbUSK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JbUSK.png" alt="table"></a>
 This is the create statement of the table. </p>

<pre><code>CREATE TABLE `currency` (
  `ID` int(10) unsigned NOT NULL,
  `Name` varchar(100) NOT NULL,
  `Abbreviation` varchar(10) NOT NULL,
  `symbol` varchar(5) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE = InnoDB DEFAULT CHARSET = latin1;
</code></pre>

<p>And all I want to do is insert symbols for them, but its not working.
I tried doing it this way.</p>

<pre><code>insert into currency (id, symbol ) values (1,'€') ;
insert into currency (id, symbol ) values (2,'$') ;
</code></pre>