Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can't input chinese in db manager sql window #53427

Closed
2 tasks
shakespare opened this issue Jun 10, 2023 · 4 comments
Closed
2 tasks

Can't input chinese in db manager sql window #53427

shakespare opened this issue Jun 10, 2023 · 4 comments
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! DB Manager Relating to the DB Manager core plugin Feedback Waiting on the submitter for answers Upstream Needs changes in an upstream library (like Qt, Proj, GDAL, ...)

Comments

@shakespare
Copy link

What is the bug or the crash?

Can't input chinese in db manager sql window

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

Additional context

No response

@shakespare shakespare added the Bug Either a bug report, or a bug fix. Let's hope for the latter! label Jun 10, 2023
@agiudiceandrea agiudiceandrea added DB Manager Relating to the DB Manager core plugin Localization Issues with language support in numbers representation and removed Localization Issues with language support in numbers representation labels Jun 12, 2023
@agiudiceandrea
Copy link
Contributor

@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?

@agiudiceandrea agiudiceandrea added the Feedback Waiting on the submitter for answers label Jun 12, 2023
@shakespare
Copy link
Author

Thank you for reply!
Information in About dialog:
QGIS version
3.30.2-'s-Hertogenbosch
QGIS code revision
0992b53
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
Copy link
Collaborator

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

@nyalldawson nyalldawson added the Upstream Needs changes in an upstream library (like Qt, Proj, GDAL, ...) label Jun 13, 2023
@jef-n
Copy link
Member

jef-n commented Sep 11, 2023

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! DB Manager Relating to the DB Manager core plugin Feedback Waiting on the submitter for answers Upstream Needs changes in an upstream library (like Qt, Proj, GDAL, ...)
Projects
None yet
Development

No branches or pull requests

4 participants