Sorry I should have said: "Running the Mahara *1.4* database on an Ubuntu host but the PHP on Windows does *NOT* work around the problem."
-- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. https://bugs.launchpad.net/bugs/760546 Title: Cannot search users with Czech characters (UTF-8 problem?) Status in Mahara ePortfolio: Triaged Bug description: Mahara version 1.2.5 (same behaviour seen with installation of version 1.3.3) platform is Windows 2003 server, PostgreSQL, IIS +PHP version 5.2.11 Every time I try to search in Mahara any user name containing national characters (e.g. nováková) 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 (see attached logfile) 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 PostgreSQL database tables in Mahara i had found that username "nováková" is saved correctly. I had already set and checked client_encoding=UTF8 variable for postgresql, even tried to set default_charset=UTF-8 variable in php.ini. To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/760546/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : [email protected] Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
