Can't input chinese in db manager sql window

shakespare commented 1 year ago

What is the bug or the crash?

Steps to reproduce the issue

1、go to menu "database" 2、click on db manager 3、connect to a database 4、click sql window icon 5、input a sql sentence containing chinese character，chinese character don't appear

Versions

3.28 3.30

Supported QGIS version

[ ] I'm running a supported QGIS version according to the roadmap.

New profile

[ ] I tried with a new QGIS profile

Additional context

No response

agiudiceandrea commented 1 year ago

@shakespare, thanks for reporting. Please provide the requested info: "In the QGIS Help menu -> About, click in the table, Ctrl+A and then Ctrl+C. Finally paste here. Do not make a screenshot." Does the Chinese characters appear if entered in other dialog window in QGIS? If yes, in what dialog windows?

shakespare commented 1 year ago

Thank you for reply! Information in About dialog: QGIS version 3.30.2-'s-Hertogenbosch QGIS code revision 0992b533 Qt version 5.15.3 Python version 3.9.5 GDAL/OGR version 3.6.4 PROJ version 9.2.0 EPSG Registry database version v10.082 (2023-02-06) GEOS version 3.11.2-CAPI-1.17.2 SQLite version 3.41.1 PDAL version 2.5.2 PostgreSQL client version unknown SpatiaLite version 5.0.1 QWT version 6.1.6 QScintilla2 version 2.13.1 OS version Windows 10 Version 1809

Active Python plugins batch_gps_importer version 1.0.1 china_transform_tool 0.1 ClipMultipleLayers 3.2.0 closest_points 1.0.1 ibamaprocessing 1.6 ImportPhotos 3.0.5 kmltools 3.1.29 LAStools 1.4 layout_panel-main 0.3 MBTiles2img 0.4 numerator 0.5 qfieldsync v4.5.0 qgis-maptiler-plugin 3.2 Qgis2threejs 2.7.1 qgis2web 3.16.0 qgis_resource_sharing 1.0.0 qtiles 1.7.2 QuickPrint 3.6.1 quick_map_services 0.19.33 QWeb 0.2.1 rasterstats 0.4.3 raster_tracer 0.3.3 RenameField 0.1 SemiAutomaticClassificationPlugin 7.10.11 SplitPolygon-master 1.2 SpreadsheetLayers 2.1.0 SRTM-Downloader 3.1.17 tianditu-tools 0.2.1 zoomview 1.1.2 db_manager 0.1.20 grassprovider 2.12.99 MetaSearch 0.3.6 otbprovider 2.12.99 processing 2.12.99

In QGIS version 3.30.2 and 3.28.7, Chinese characters can't be entered , but can be pasted into SQL window, can be entered in other dialogs such as mesh calculator,raster calculator. I tested in QGIS version 3.26.3 , Chinese characters can be entered correctly in SQL window.

nyalldawson commented 1 year ago

This is a bug in the QScintilla library -- it needs updating to 2.13.4 which includes the fix. Please file the ticket at https://trac.osgeo.org/osgeo4w/report/1?sort=created to get this updated in the Windows installer

jef-n commented 1 year ago

qgis / QGIS