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 ...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 change the database from MySQL/PostgreSQL to MSSQL
The steps mentioned below are applicable only if you migrate the DB from PgSQL to MSSQL. This means that the application server is going to remain the same. The data alone is going to be transferred to MSSQL DB from the existing PgSQL DB. For ...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 ...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 ...