[Koha-bugs] [Bug 6483] Paging in opac-detail when coming from a search

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6483

--- Comment #42 from Salva Zaragoza Rubio <salva at masmedios.com> 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&amp;query=kw,wrdl,rtrn=Caf\xC3\xA9
&amp;count=10&amp;simple_query=Caf\xC3\xA9&amp;listBiblios=29,30&amp;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&amp;query=kw,wrdl,rtrn=S\xC3\xA9
&amp;count=20&amp;simple_query=S\xC3\xA9&amp;listBiblios=25,24,23,21,18,17,16,12,7,6,4,2&amp;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 at pcbsd /usr/home/salzaru]$ echo "Café" | iconv -t UTF-8 -f ISO-8859-1 
Café

[salzaru at pcbsd /usr/home/salzaru]$ perl -e 'use Encode; print (encode("utf8",
"Café") . chr(10));'
Café

[salzaru at 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.