Chinese characters sometimes display wrong

[CKylinMC]

Hi, I was confused by one thing when I learning MySQL using mycli.
I made a query, and got a wrong result, the characters display in a wrong coding:

But when I maximized the window and redo the query, it runs correctly:

I tried the official tool and it's correct whatever I maximized the window or not:

I dumped a SQL file: mysqdumps.sql

Don't mind the content and sorry for my poor English.

[gfrlv]

Do you have wcwidth installed (check with pip freeze | grep wcwidth)?
Seems like an issue with tabulate -- a library we use to render tables.

[CKylinMC]

Do you have wcwidth installed (check with pip freeze | grep wcwidth)?
Seems like an issue with tabulate -- a library we use to render tables.

I think it has been installed automatically.

[ZDSDESIRE]

It works on my Windows 10:

1. Enter “chcp” in CMD or Windows PowerShell to view the current character encoding:
   

936: GBK
65001: UTF-8
437: OEM USA

2. Try to do that:
   

3. Try again enter "chcp" in cmd:
   
   Finish.

[CKylinMC]

@ZDSDESIRE I followed your steps and I found that CMD's "active code page" is still "936", the problem is still here.
But when I switch to use Windows Terminal, it's worked, and its "active code page" is 65001.
Thanks.

[ZDSDESIRE]

@CKylinMC
You can enter "chcp 65001" to change the current CMD window's "active code page" , but this only applies to the current window.
If you want to change the default state, you need to run the "regedit.exe".
Find the path: "\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Command Processor".
Add or modify the option "Autorun" whose value is "chcp 65001".

[CKylinMC]

It works. Thanks!