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