[BUG]: Geopackage reader: For Geopackages containing a boolean field, the value 'true' is read as '1'

[JohannaOtt]

Describe the bug
When importing a geopackage file containing a boolean field with true values, the values are read as 1

To Reproduce
Steps to reproduce the behavior:

1. Go to Import source schema and import the attached geopackage as schema
2. Go to Import source data and import the geopackage as source data
3. Rightclick on BoolField in the Schema Explorer and open the Properties
4. Chose the section Occurring values
5. Click the refresh button and the occurring values - it is 1

testExportFlo.zip

Expected behavior
I would expect the occurring value to be true as this is the value I assigned to the field when creating the geopackage file with hale»studio.

Additional context
I am using Version 5.1.0. release
Build 202402261605
Revision 883baf4

When loading the data to QGIS, the value is true as expected which is why the error must be in the Geopackage reader, not the writer.

[github-actions]

This issue has been automatically marked as stale because it has not had activity in the last 60 days. It will be closed in two weeks if no further activity occurs. Thank you for your contributions.