** Attachment added: "PHP error log file (search problem, UTF-8)" https://bugs.launchpad.net/bugs/760546/+attachment/2033699/+files/mahara-search-utf8-fail.txt
-- 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: New 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. _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
