<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body>A new request with request id 16156 has been created by koha-devel-request@lists.koha-community.org. Short info on the request is : <br><br>Title : Koha-devel Digest, Vol 189, Issue 14<br>Category : <br>Description : <div>Send Koha-devel mailing list submissions to<br> koha-devel@lists.koha-community.org<br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>or, via email, send a message with subject or body 'help' to<br> koha-devel-request@lists.koha-community.org<br><br>You can reach the person managing the list at<br> koha-devel-owner@lists.koha-community.org<br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of Koha-devel digest..."<br><br><br>Today's Topics:<br><br> 1. Character sets in MariaDB 10.5 (Michael Kuhn)<br> 2. Re: Character sets in MariaDB 10.5 (Tomas Cohen Arazi)<br> 3. Koha 19.11.21 released (Wainui Witika-Park)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Wed, 25 Aug 2021 22:53:18 +0200<br>From: Michael Kuhn <mik@adminkuhn.ch><br>To: koha-devel <koha-devel@lists.koha-community.org>,<br> "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz><br>Subject: [Koha-devel] Character sets in MariaDB 10.5<br>Message-ID: <0011807a-5ea6-cbed-6c9c-81e92f7cb9da@adminkuhn.ch><br>Content-Type: text/plain; charset=utf-8; format=flowed<br><br>Hi<br><br>1. In the last few years when installing Koha on Debian GNU/Linux 9 or <br>10 the character sets in MariaDB were as follows:<br><br>MariaDB [(none)]> SHOW VARIABLES LIKE '%char%';<br>+--------------------------+----------------------------+<br>| Variable_name | Value |<br>+--------------------------+----------------------------+<br>| character_set_client | utf8mb4 |<br>| character_set_connection | utf8mb4 |<br>| character_set_database | utf8mb4 |<br>| character_set_filesystem | binary |<br>| character_set_results | utf8mb4 |<br>| character_set_server | utf8mb4 |<br>| character_set_system | utf8 |<br>| character_sets_dir | /usr/share/mysql/charsets/ |<br>+--------------------------+----------------------------+<br><br>Today I installed Koha 21.05.03 on Debian GNU/Linux 11 with MariaDB <br>10.5.11 where the character sets are as follows:<br><br>MariaDB [(none)]> SHOW VARIABLES LIKE '%char%';<br>+--------------------------+----------------------------+<br>| Variable_name | Value |<br>+--------------------------+----------------------------+<br>| character_set_client | utf8 |<br>| character_set_connection | utf8 |<br>| character_set_database | utf8mb4 |<br>| character_set_filesystem | binary |<br>| character_set_results | utf8 |<br>| character_set_server | utf8mb4 |<br>| character_set_system | utf8 |<br>| character_sets_dir | /usr/share/mysql/charsets/ |<br>+--------------------------+----------------------------+<br><br>I'm not sure what is going on here. Does anyone know why the character <br>sets for client, connection and results have changed from utf8mb4 to <br>utf8? Is this correct with Koha or should these character sets be changed?<br><br>2. Today I came upon an installation of Koha 18.11.05 using MariaDB <br>10.0.32 which has the following character sets:<br><br>MariaDB [(none)]> SHOW VARIABLES LIKE '%char%';<br>+--------------------------+----------------------------+<br>| Variable_name | Value |<br>+--------------------------+----------------------------+<br>| character_set_client | utf8 |<br>| character_set_connection | utf8 |<br>| character_set_database | latin1 |<br>| character_set_filesystem | binary |<br>| character_set_results | utf8 |<br>| character_set_server | latin1 |<br>| character_set_system | utf8 |<br>| character_sets_dir | /usr/share/mysql/charsets/ |<br>+--------------------------+----------------------------+<br><br>This seems quite wrong to me - as far as I know "latin1" was never a <br>supported character set in Koha... as far as I know the character sets <br>should be set as shown in topic 1.<br><br>However, is it still possible to update such a database with these <br>character sets to Koha 21.05.03 without destroying the data completely?<br><br>Best wishes: Michael<br>-- <br>Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis<br>Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz<br>T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch<br><br><br>------------------------------<br><br>Message: 2<br>Date: Wed, 25 Aug 2021 20:03:39 -0300<br>From: Tomas Cohen Arazi <tomascohen@gmail.com><br>To: Michael Kuhn <mik@adminkuhn.ch><br>Cc: koha-devel <koha-devel@lists.koha-community.org>, koha<br> <koha@lists.katipo.co.nz><br>Subject: Re: [Koha-devel] Character sets in MariaDB 10.5<br>Message-ID:<br> <CABZfb=VXsRxp0eCV_tFhnJSraCW26bkYGkZ8vgQk4FmD4ncx5g@mail.gmail.com><br>Content-Type: text/plain; charset="utf-8"<br><br>Those are just defaults in the OS distribution, that can be changed at will.<br><br>Koha, internally, sets the character set correctly on connection time [1].<br><br>You should always check when they drop support for our used encodings.<br>Which is not the case (for now?). We have the test suite run against the<br>latest versions of MariaDB for that purpose.<br><br>I recommend you set that defaults correctly so they are picked when you use<br>the CLI.<br><br>Best regards<br><br>[1]<br>https://git.koha-community.org/Koha-community/Koha/src/branch/master/Koha/Database.pm#L74<br><br>El mié., 25 ago. 2021 17:54, Michael Kuhn <mik@adminkuhn.ch> escribió:<br><br>> Hi<br>><br>> 1. In the last few years when installing Koha on Debian GNU/Linux 9 or<br>> 10 the character sets in MariaDB were as follows:<br>><br>> MariaDB [(none)]> SHOW VARIABLES LIKE '%char%';<br>> +--------------------------+----------------------------+<br>> | Variable_name | Value |<br>> +--------------------------+----------------------------+<br>> | character_set_client | utf8mb4 |<br>> | character_set_connection | utf8mb4 |<br>> | character_set_database | utf8mb4 |<br>> | character_set_filesystem | binary |<br>> | character_set_results | utf8mb4 |<br>> | character_set_server | utf8mb4 |<br>> | character_set_system | utf8 |<br>> | character_sets_dir | /usr/share/mysql/charsets/ |<br>> +--------------------------+----------------------------+<br>><br>> Today I installed Koha 21.05.03 on Debian GNU/Linux 11 with MariaDB<br>> 10.5.11 where the character sets are as follows:<br>><br>> MariaDB [(none)]> SHOW VARIABLES LIKE '%char%';<br>> +--------------------------+----------------------------+<br>> | Variable_name | Value |<br>> +--------------------------+----------------------------+<br>> | character_set_client | utf8 |<br>> | character_set_connection | utf8 |<br>> | character_set_database | utf8mb4 |<br>> | character_set_filesystem | binary |<br>> | character_set_results | utf8 |<br>> | character_set_server | utf8mb4 |<br>> | character_set_system | utf8 |<br>> | character_sets_dir | /usr/share/mysql/charsets/ |<br>> +--------------------------+----------------------------+<br>><br>> I'm not sure what is going on here. Does anyone know why the character<br>> sets for client, connection and results have changed from utf8mb4 to<br>> utf8? Is this correct with Koha or should these character sets be changed?<br>><br>> 2. Today I came upon an installation of Koha 18.11.05 using MariaDB<br>> 10.0.32 which has the following character sets:<br>><br>> MariaDB [(none)]> SHOW VARIABLES LIKE '%char%';<br>> +--------------------------+----------------------------+<br>> | Variable_name | Value |<br>> +--------------------------+----------------------------+<br>> | character_set_client | utf8 |<br>> | character_set_connection | utf8 |<br>> | character_set_database | latin1 |<br>> | character_set_filesystem | binary |<br>> | character_set_results | utf8 |<br>> | character_set_server | latin1 |<br>> | character_set_system | utf8 |<br>> | character_sets_dir | /usr/share/mysql/charsets/ |<br>> +--------------------------+----------------------------+<br>><br>> This seems quite wrong to me - as far as I know "latin1" was never a<br>> supported character set in Koha... as far as I know the character sets<br>> should be set as shown in topic 1.<br>><br>> However, is it still possible to update such a database with these<br>> character sets to Koha 21.05.03 without destroying the data completely?<br>><br>> Best wishes: Michael<br>> --<br>> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis<br>> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz<br>> T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch<br>> _______________________________________________<br>> Koha-devel mailing list<br>> Koha-devel@lists.koha-community.org<br>> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>> website : https://www.koha-community.org/<br>> git : https://git.koha-community.org/<br>> bugs : https://bugs.koha-community.org/<br>><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20210825/b00def01/attachment-0001.htm><br><br>------------------------------<br><br>Message: 3<br>Date: Thu, 26 Aug 2021 13:42:46 +1200<br>From: Wainui Witika-Park <wainuiwitikapark@catalyst.net.nz><br>To: koha@lists.katipo.co.nz, koha-devel@lists.koha-community.org<br>Subject: [Koha-devel] Koha 19.11.21 released<br>Message-ID: <91f4eecb-b083-cd23-859b-a49167b19dd2@catalyst.net.nz><br>Content-Type: text/plain; charset=utf-8<br><br>Hello everyone!<br><br>The Koha community is proud to announce the release of version 19.11.21.<br><br>The full release notes can be found at:<br>https://koha-community.org/koha-19-11-21-released/<br><br>Thank you to everyone involved!<br><br>Cheers,<br><br>Wainui Witika-Park (she/her)<br><br><br>------------------------------<br><br>Subject: Digest Footer<br><br>_______________________________________________<br>Koha-devel mailing list<br>Koha-devel@lists.koha-community.org<br>https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>website : https://www.koha-community.org/<br>git : https://git.koha-community.org/<br>bugs : https://bugs.koha-community.org/<br><br><br>------------------------------<br><br>End of Koha-devel Digest, Vol 189, Issue 14<br>*******************************************<br></div><br><br>NOTE: You are receiving this mail because, the Requester/Technician wanted you to get notified on this request creation.<br></body></html>