So I was greeted with "I can't see my words today" as it turns out she was trying to write a status in Chinese on that website I'm slowly building up so I changed the collation to utf8_unicode_ci and made sure I used htmlspecialchars for the input field, however now when it returns the row instead of showing:
Test
Test
It now shows Test Test as the output on the page
When I look in the database at that row it dose show as:
Test
Test
So I'm a bit lost I haven't changed anything else.