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 ...
                    • 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 ...
                    • 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 ...
                    • 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, |, ...
                    • Mail Fetching: Subject Contains Unwanted Characters and Garbled Text

                      Issue: We use MIME for processing emails obtained from EWS. Unwanted characters and garbled text are present in the subject when fetching it from the MIME after decoding. Восстановить стату�� ACSID\WSID в базе Omega [2L] Ð Ð±Ð½Ð°Ñ Ñ Ð¶ÐµÐ½Ð¾ ...