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
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.