09 November 2010, 6:25

Hello,

Our platform is Windows 2003 server, PostgreSQL, IIS+PHP version 5.2.11, Mahara version 1.2.5

I have following problem.

Every time I try to search any user name which contains national characters (e.g. nováková) in Mahara  only error page shows up.

"A nonrecoverable error occured. This probably means you have encountered a bug in the system"

Searching names without national characters works OK.

In PHP error log i have noticed this:

Failed to get a recordset: postgres7 error: [-1: ERROR:  invalid byte sequence for encoding "UTF8": 0xe3a16b

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".] in EXECUTE("...

Database in PostgreSQL was created using following command:
CREATE DATABASE ...
  WITH OWNER = ....
       ENCODING = 'UTF8'
       LC_COLLATE = 'Czech, Czech Republic'
       LC_CTYPE = 'Czech, Czech Republic'
       CONNECTION LIMIT = -1;

When i checked inside database tables in Mahara i found that username "nováková" is saved correctly. 

I think that string have to be scrambled somehow en route.

Any help would be appreciated.

Adrian