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 :
- 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.
- This issue can occur in Postgres less than 11.17 i-e Build version less than 14300.
Solution :
- 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.
- #Command to change the encoding to "UTF-8"
- chcp 65001
New to ADSelfService Plus?
Related Articles
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] Ð Ð±Ð½Ð°Ñ Ñ Ð¶ÐµÐ½Ð¾ ...How to resolve Connectivity issues with Postgresql Database from our product?
Log Traces Feb 20, 2024 6:40:00 PM [SYSERR] [INFO] : java.sql.SQLException: java.lang.Exception: Exception during getConnection from pool Exception occurred during get connection from datasource Nov 15, 2023 1:29:10 PM [SYSERR] [INFO] : Caused by: ...