Hi,

I'm working on a postgres project which has table/database encoding set to UTF8.

If I now create a query with sqlquery containing speciale symbols (even ü ä ë), the query fails complaining:

HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".

Can I set this anywhere in Roxen?

Currently I use the following RXML/Pike code:

<?pike var.query=string_to_utf8(var.query) ?>

But I'm not sure if this hasn't any corner-cases because afterwards the string is escaped to :mysql;

Marc

Reply via email to