I've got a Joomla/CiviCRM set-up that I'm making some changes to using PHP and MySQL, however am having one problem with char encoding. When CiviCRM is saving data it's saving it as Submitted in MySQL. This wouldn't be a problem, but I need this to display simply as 'Submitted' in my coding. The database uses utf8_unicode_ci and CiviCRM runs on utf8 so I don't know why it writes it to the database like this, and I've not been able to get much help on this at te CiviCRM forum. However, does anyone know how I could take what's in the database and have it displayed without any extra characters using a simple PHP query?

Many thanks,