[Koha-bugs] [Bug 18336] Use utf8mb4 instead of utf8 for MySQL tables, columns, and connections

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Fri Feb 16 19:20:20 CET 2018


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18336

Kyle M Hall <kyle at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #71779|0                           |1
        is obsolete|                            |
  Attachment #71780|0                           |1
        is obsolete|                            |
  Attachment #71781|0                           |1
        is obsolete|                            |
  Attachment #71782|0                           |1
        is obsolete|                            |
  Attachment #71783|0                           |1
        is obsolete|                            |
  Attachment #71784|0                           |1
        is obsolete|                            |
  Attachment #71785|0                           |1
        is obsolete|                            |
  Attachment #71786|0                           |1
        is obsolete|                            |
  Attachment #71836|0                           |1
        is obsolete|                            |

--- Comment #58 from Kyle M Hall <kyle at bywatersolutions.com> ---
Created attachment 71843
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=71843&action=edit
Bug 18336: Full stack tests for supplemental UTF-8 chars

This patch introduces tests for Koha's support for 4-byte supplemental
UTF-8 chars. encoding/decoding tools handle this gracefuly. The missing
piece is the MySQL DB backend.

The tests in this patch:
- Adds a couple records for each flavour (MARC21 and UNIMARC) so
  search_utf8.t tests 4-byte chars are handled correctly
- Adds emoji testing in auth_values_input_www.t

To test:
- Apply this patch
- Run:
  $ kshell
 k$ prove t/db_dependent/www/search_utf8.t \
          t/db_dependent/www/auth_values_input_www.t
=> FAIL: It should fail if the DB hasn't been migrated into using
utf8mb4

Sponsored-by: Hotchkiss School

Signed-off-by: Mark Tompsett <mtompset at hotmail.com>

Signed-off-by: Katrin Fischer <katrin.fischer.83 at web.de>
Signed-off-by: Tomas Cohen Arazi <tomascohen at theke.io>

Signed-off-by: Kyle M Hall <kyle at bywatersolutions.com>

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


More information about the Koha-bugs mailing list