Non English characters is shown as Garbled Text when updating in postgres database through cmd

Non English characters is shown as Garbled Text when updating in postgres database through cmd


Issue : 

      Non English characters is shown as Garbled Text when updating in postgres database through command prompt. say for example, 同意(自动通过) is being saved as ͬÒâ(×Ô¶¯Í¨¹ý) when updating via windows command prompt.

Reference Ticket : #8633870

Root Cause : 

  1. In some of the customer environments, the default encoding of  command prompt may differ from "UTF-8" . such encoding may not handle all the non -english data effectively. The root cause of this issue is, character encoding mismatch or misinterpretation during the data update process.
  2. This issue can occur in Postgres less than 11.17 i-e Build version less than 14300.
Solution :
  1. This is a known issue from the Postgres side. This issue is fixed in Postgres version 11.17. We can resolve it by, either upgrading the setup to 14300 or changing the encoding to "UTF-8". We are highly recommending you upgrade to build 14300. If it is not possible, you can resolve it executing the below command in command prompt of the corresponding machine where query is executed.

  1. #Command to change the encoding to "UTF-8" 
  2. chcp 65001


                  New to ADSelfService Plus?

                    • Related Articles

                    • Query Executor Tool for Postgres

                      Overview: A query executor tool for PostgreSQL that allows for query execution without a direct database connection enhances security and flexibility while collaborating on query testing without the need for each team member to have direct database ...
                    • Migration failure for Postgres Database with a blank space in it

                      Trace : \ManageEngine\ServiceDesk\Patch\AdventNet_ManageEngine_ServiceDesk_Plus-14.2.0-SP-1.0.0\SERVICEDESK\PreInstall\pg_migrate\pgsql_old\bin\pg_dumpall.exe", -U, postgres, -p, 65433, -h, 127.0.0.1, -r, -w, |, ...
                    • How to Connect External Postgres

                      Install a External Postgres such that the version of that postgres is currently in the series of inbuilt postgres of our Application. Say for example, In Servicedeskplus Application version 14010, which has postgres version 10.21, then you should ...
                    • Remote read only access to database for Postgres customers

                      Frequently customers want to connect some reporting / dashboard application like PowerBI or Tableau with our Postgres database server. By default, the bundled Postgres is configured to only listen to the local machine. We can configure to allow ...
                    • Headers are in English / Partial content is in English / Application Keys are shown after upgrade

                      Issue: Any of the following issues can occur. Issue can occur post upgrade too. Even if application is set to non-english language, headers are shown in English. Some portion in the application is still in English while the rest of the application is ...