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
|