The query result is messed up in Chinese

[iknownoth1ng]

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

[dbaty]

Thanks for your report. Do you have a way to reproduce this bug? I don't speak nor write Chinese, so my naïve attempt did not produce anything suspicious when running in pgcli:

> create table chinese_chars (t text);
CREATE TABLE
> insert into chinese_chars (t) values ('繁体字')
INSERT 0 1
> select * from chinese_chars
+--------+
| t      |
|--------|
| 繁体字  |
+--------+
SELECT 1

I am looking for a particular insert into query that would trigger this bug. Also, do you have this issue within pgcli itself? Your screenshots have timestamps and line numbers: could it be that you are using a distinct tool to read a file produced by pgcli?

[dbaty]

See also #833 for the same bug reported by someone else. (Given that both have been reported years ago, I'll keep both issues so that both reporters have a chance to say whether they still have this error.)