Just reporting back..
This was an encoding issue DB vs web page.
Solved by adding a charset to the database connections file.
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_connection_name = "localhost";
$database_connection_name= "DatabaseNAME";
$username_connection_name= "UserNAME";
$password_connection_name= "Password";
$connection_name= mysql_pconnect($hostname_wtse_adm, $username_connection_name, $password_connection_name) or trigger_error(mysql_error(),E_USER_ERROR);
?>
Simply add this with your charset to the end:
mysql_set_charset('utf8',$connection_name);
So it will look like this:
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_connection_name = "localhost";
$database_connection_name= "DatabaseNAME";
$username_connection_name= "UserNAME";
$password_connection_name= "Password";
$connection_name= mysql_pconnect($hostname_wtse_adm, $username_connection_name, $password_connection_name) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_set_charset('utf8',$connection_name);
?>
Or you can use a DA Dynamic Connection which allows you to set the charset.