I have php code that is submitting a string to two postgresql databases on two different servers.
The string is:
'£pound €euro'
PHP Server Version:
Server 1 version:
Server 2 version:
The server encoding for both is UTF8
The client_encoding is also UTF8
The locale for both servers are the same also.
The following code is used to execute the query:
$oConn=@pg_Connect('host=$myip dbname=$mydb user=$myuser password=$mypassword');
$sql = "select * from _myfunction($mystring)";
$result=@pg_query($oConn, $sql);
What I'm finding happening is that when the query is executed, the following is being received by Server 1:
select * from _myfunction('£pound €euro')
Yet on Server 2 the following is being received:
select * from _myfunction('£pound �euro')
Does anybody have a clue on where I could look to figure out what is causing the difference to the query being received between the two servers. Seeing Server 2's query is turning funky, invalid byte sequence errors in other parts of the database are causing an issue.
I'm stumped. The only difference I can see is the minor versions of postgresql.
I guess your postgree charset is not the same in both servers. See How can i change database encoding for a PostgreSQL database using sql or phpPgAdmin? , it may help you