The query result is messed up in Chinese
- 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!!!


## 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
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