Forums | Mahara Community
UTF-8 problem? Cannot search users in Mahara
22 March 2011, 7:39 AM
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 has already set&checked client_encoding=UTF8 variable for postgresql, even set default_charset=UTF-8 variable in php.ini.
All to no avail
Any help would be greatly appreciated.