is there a native php function which can escape strings with umlautes correctly for postresql?

Question

Hi,

i used the functions pg_escape_bytea() and pg_escape_string() but i had to find out that there are several problems with umlautes:

if i do pg_escape_bytea("pöl") , where "pöl" is utf8 i get "p\\303\\266l", and i cannot compare this with my values in the tabels ... so what can i do?

have somebody written a function so far, which escapes my string correctly with umlauts?

thx

Answer 1

Why don't you use pg_escape_string() or pg_query_params() to escape a string as a string? The value "pöl" doesn't look like binary data, it looks like a string.