[Koha-bugs] [Bug 9498] Update encoding for Norwegian sample Z39.50 servers

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

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

Bernardo Gonzalez Kriegel <bgkriegel at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #15296|0                           |1
        is obsolete|                            |

--- Comment #2 from Bernardo Gonzalez Kriegel <bgkriegel at gmail.com> ---
Created attachment 15423
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=15423&action=edit
[SIGNED-OFF] Bug 9498 - Update encoding for Norwegian sample Z39.50 servers

The encoding for sample Z39.50 servers loaded when doing a nb-NO
install has been wrong all along, resulting in "norwegian vowels"
(æøå) being displayed as weird chars when records are fetched via
Z39.50.

This patch
- Updates the sample servers installed by the web installer
- Does a database upgrade that changes the encoding for the servers
  in question

To test:
- Do a Norwegian installation and make sure to choose the optional
  sample Z39.50 targets
- Check that encodings for the Norwegian targets (BIBSYS, SAMBOK,
  NORBOK and DEICHMAN) are all set to ISO_6937 (which is the wrong
  encoding)
- Apply this patch and make sure updatadatabase.pl is run
- Check that the encoding for the four targets mentioned above are
  now ISO_8859-1
- Do one search against each target and check that there are no
  "strange" chars in the result list. Searching each of the targets
  for "hessen" should give results that include "norwegian vowels"
- Log on to the MySQL of the test installation and empty the table
  of Z39.50 targets:
  mysql> delete from z3950servers;
- Load this file into MySQL from the command line:
  installer/data/mysql/nb-NO/2-Valgfritt/z3950servers.sql
  and check that it loads without errors and that the four
  Norwegian targets are still set to have encoding = ISO_8859-1

Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel at gmail.com>

Comment: Work as described. No errors.
Test:
1) NOTE: I didn't do a Norwegian install, only tested z39.50 servers output
2) Removed default z39 targets, installed norwegian ones
3) Checked previous z39.50 servers encoding
4) Pre-patch sample search "hessen"
BIBSYS    Hessen im Frþhmittelalter
BIBSYS    System der Gemeindebesteuerung in Hessen, Wþrttemberg, Baden,
Elsa⅞-Lothringen, Bayern, Sachsen, Preu⅞en
DEICHMAN    De danske troppers h�derskrands. Eller det danske auxiliair-corps
under anf. af prinds Frederik af Hessen
NORBOK    �tte-tavle for l�rer Johan P. Eidsvig og g�rdbr. Nikolai Nikolaisen
Hessen
SAMBOK    ErlĦuterungen zur Geologischen Karte von Hessen
5) Applied patch, run updatedatabase
6) Checked sample servers encoding Ok
7) Post-patch sample search "hessen"
BIBSYS    Hessen im Frühmittelalter
BIBSYS    System der Gemeindebesteuerung in Hessen, Württemberg, Baden,
Elsaß-Lothringen, Bayern, Sachsen, Preußen
DEICHMAN    De danske troppers hæderskrands. Eller det danske auxiliair-corps
under anf. af prinds Frederik af Hessen
NORBOK    Ætte-tavle for lærer Johan P. Eidsvig og gårdbr. Nikolai Nikolaisen
Hessen
SAMBOK    Erläuterungen zur Geologischen Karte von Hessen
8) Sample servers deleted and installed from command line, same result as 6)
and 7)

No koha-qa errors

-- 
You are receiving this mail because:
You are watching all bug changes.