Bug#974640: Spatialite GUI /CLI and shp

[jedei]

Package: spatialite-gui
Version: 2.1.0~beta1-1
Severity: normal

Hi,

Importing or linking a shapefile in spatialite (spatialite_gui, sqlite3 with 
mod_spatialite) fails if the extension is in uppercase (.SHP).

This problem does not exist with csv / txt, xls, GeoJson, or dbf, or zip files 
(ZipFile archive for shapefile). However if the extension of these files is in 
uppercase they do not appear in the search window and the type must be set to 
"All files" to make them appear and select them.

I am using Linux debian 5.6.0-2-amd64 #1 SMP Debian 5.6.14-2 (2020-06-09) 
x86_64 GNU/Linux (Bullseye testing 20200622 with partial update (sqlite3, 
spatialite) 20201003). My desktop environment is MATE 1.24.

Best regards

Michel‌

Bug#971698: Spatialite GUI and unicode

[jedei]

Package: spatialite-gui
Version: 2.1.0~beta1-1
Severity: normal‌

Hi,

In spatialite_gui the following query causes a bug as soon as the "è" character 
is typed even before having executed the query : SELECT code_insee, nom_com, 
FROM communes_bdp WHERE nom_com = 'Anè
[Error message]
An assertion failed!
../src/common/unichar.cpp(65):assert "Assert failure" failed in ToHi8bit(): 
character cannot be converted to single byte

The same query with sqlite3 and mod_spatialite works fine.

I am using Linux debian 5.6.0-2-amd64 #1 SMP Debian 5.6.14-2 (2020-06-09) 
x86_64 GNU/Linux (Bullseye testing 20200622 with partial update (sqlite3, 
spatialite) 20201003)

Best regards

Michel