Related Tips & Info
Wikis - Page

DB error encoding "UTF8" has no equivalent in encoding "WIN1252"

Junbo Zhang
 
0 Likes

Situation

An error occurs when executing query commands after logging in to NNMi Postgres.

nnm=# select * from nms_interface_groups;
ERROR: character with byte sequence 0xe3 0x82 0xa4 in encoding "UTF8" has no equivalent in encoding "WIN1252"
 

Resolution

1.Confirm the current encoding information through the command
nnm=# show client_encoding;

2.If it is the following result

client_encoding
------------------
WIN1252
(1 row)

Modify the encoding by executing the following command
\encoding utf-8

 

3.Confirm again whether the modification is successful

nnm=# show client_encoding;
client_encoding
-----------------
UTF8
(1 row)

There will be no more errors when executing the query。

Labels:

Support Tips/Knowledge Docs
Comment List
Related
Recommended

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.