Bug 11906: ensure that Koha::Database uses UTF8 mode when connecting to databases
authorGalen Charlton <gmc@esilibrary.com>
Wed, 26 Mar 2014 20:38:32 +0000 (20:38 +0000)
committerGalen Charlton <gmc@esilibrary.com>
Thu, 27 Mar 2014 14:44:48 +0000 (14:44 +0000)
commit05a6beba9f023f87d3355b6e72f35b220cd691b0
treeec8c8ebcbb9e5b5b63e1241a9e1a75b0fc8ae9b0
parentb21d16ca75bb40371773d3008fcb06c67200ab36
Bug 11906: ensure that Koha::Database uses UTF8 mode when connecting to databases

This patch fixes an issue whereby the DBIx::Class schema objects
were not connecting to the underlying database in UTF8 mode.  This
most visibility manifested as patron list pages not displaying
diacritics correctly.

To test:

[1] Create a patron list, and make sure that it contains at least
    one patron whose name or patron category description contains
    a non-ASCII character.
[2] View the list contents; the diacritics should appear mangled.
[3] Apply the patch.
[4] View the patron list again.  This time, the diacritics should
    be displayed correctly.  Note that Apache will also log
    "list.pl: Wide character in print ...", but this is the lesser
    of two evils.
[5] Verify that prove -v t/db_dependent/Koha_Database.t passes.
[6] (extra credit) Verify that  t/db_dependent/Koha_Database.t
    passes when connect to a PostgreSQL database.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>

Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com>
Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Koha/Database.pm