mahara-contributors team mailing list archive
-
mahara-contributors team
-
Mailing list archive
-
Message #03267
[Bug 760546] Re: Cannot search users with Czech characters (UTF-8 problem?)
Hi Adrian,
Thanks for creating a bug for this and for testing on 1.3.3.
If you could also test it with the latest development version of Mahara,
that would be quite helpful. I haven't been able to reproduce the bug
myself.
To do that, go to this page:
http://gitorious.org/mahara/mahara/commits/master
and click the "download master as tar.gz" button in the right sidebar.
Cheers,
Francois
** Changed in: mahara
Importance: Undecided => Medium
** Changed in: mahara
Status: New => Triaged
** Tags added: iis windows
--
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.
References