dbcli / dbcli/pgcli

The query result is messed up in Chinese

Open
#1,411 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
13.4k
Forks
612
Avg merge
6d 14h
Merged PRs (30d)
10

Description

## Description

select * from table_name limit 10;
OK!!!

select * from table_name;
garbled!!!
![中文乱码](https://github.com/dbcli/pgcli/assets/54530758/4967561e-83ba-4a31-90b7-0447226dbbca)
![编码信息](https://github.com/dbcli/pgcli/assets/54530758/356297ef-d8ca-4ab1-a506-3817192873ce)

## Your environment

os: win10
Server: PostgreSQL 11.3
pgcli-Version: 3.5.0
- [ ] What is the output of ``pip freeze`` command.
bcrypt==4.0.1
cffi==1.15.1
cli-helpers==2.3.0
click==8.1.3
colorama==0.4.6
configobj==5.0.8
cryptography==36.0.2
importlib-resources==5.12.0
mycli==1.26.1
paramiko==3.2.0
pendulum==2.1.2
pgcli==3.5.0
pgspecial==2.1.0
prompt-toolkit==3.0.38
psycopg==3.1.9
psycopg-binary==3.1.9
psycopg2==2.9.6
pyaes==1.6.1
pycparser==2.21
Pygments==2.15.1
PyMySQL==1.1.0
PyNaCl==1.5.0
pyperclip==1.8.2
python-dateutil==2.8.2
pytzdata==2020.1
setproctitle==1.3.2
six==1.16.0
sqlglot==16.8.1
sqlparse==0.4.4
sshtunnel==0.4.0
tabulate==0.9.0
typing_extensions==4.7.1
tzdata==2023.3
wcwidth==0.2.6
zipp==3.15.0

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the two queries in pgcli 3.5.0 on Windows 10 against PostgreSQL 11.3, comparing the limited and unlimited results shown in the issue. Trace how query output encoding is handled, using the supplied screenshots and environment details; done means Chinese characters render correctly in the full result as well as the limited result.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, python
Domain
cli, databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.