http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6483
--- Comment #42 from Salva Zaragoza Rubio <[email protected]> 2011-08-24 20:51:05 UTC --- I can't seem to recreate the bug reported by Frédéric with the accented characters. I've tested the patch with Koha running on servers OpenBSD 4.9 and FreeBSD 8.2 without success. OS FreeBSD: ----------- Table sessions in mysql: mysql> show create table sessions; | sessions | CREATE TABLE `sessions` ( `id` varchar(32) NOT NULL, `a_session` text NOT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 | mysql> SELECT CCSA.character_set_name FROM information_schema.`TABLES` T, -> information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA -> WHERE CCSA.collation_name = T.table_collation AND T.table_name = 'sessions'; +--------------------+ | character_set_name | +--------------------+ | utf8 | +--------------------+ Query: Café busc variable on session: busc: "q=Caf\xC3\xA9&query=kw,wrdl,rtrn=Caf\xC3\xA9 &count=10&simple_query=Caf\xC3\xA9&listBiblios=29,30&total=2" Link back to results: Opera on PCBSD: http://192.168.1.12:8079/cgi-bin/koha/opac-search.pl?q=Caf%C3%A9 SeaMonkey on PCBSD: http://192.168.1.12:8079/cgi-bin/koha/opac-search.pl?q=Caf%C3%A9 Chromium on PCBSD: http://192.168.1.12:8079/cgi-bin/koha/opac-search.pl?q=Caf%C3%A9 When returns always shows Café with the accent fine. OS OpenBSD: ----------- mysql> show create table sessions; | sessions | CREATE TABLE `sessions` ( `id` varchar(32) NOT NULL, `a_session` text NOT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 | mysql> SELECT CCSA.character_set_name FROM information_schema.`TABLES` T, -> information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA -> WHERE CCSA.collation_name = T.table_collation AND T.table_name = 'sessions'; +--------------------+ | character_set_name | +--------------------+ | utf8 | +--------------------+ Query: Sé busc variable on session: busc: "q=S\xC3\xA9&query=kw,wrdl,rtrn=S\xC3\xA9 &count=20&simple_query=S\xC3\xA9&listBiblios=25,24,23,21,18,17,16,12,7,6,4,2&total=12" Link back to results: Opera on PCBSD: http://192.168.1.14:8079/cgi-bin/koha/opac-search.pl?q=S%C3%A9 SeaMonkey on PCBSD: http://192.168.1.14:8079/cgi-bin/koha/opac-search.pl?q=S%C3%A9 Chromium on PCBSD: http://192.168.1.14:8079/cgi-bin/koha/opac-search.pl?q=S%C3%A9 When returns always shows Sé with the accent fine. I've seen that café is the utf8 codification of Café, maybe there's a codification in some place, but in the patch there is not one. [salzaru@pcbsd /usr/home/salzaru]$ echo "Café" | iconv -t UTF-8 -f ISO-8859-1 Café [salzaru@pcbsd /usr/home/salzaru]$ perl -e 'use Encode; print (encode("utf8", "Café") . chr(10));' Café [salzaru@pcbsd /usr/home/salzaru]$ perl -e 'use Encode; print (decode("utf8", "café") . chr(10));' café Any ideas? -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
