postgresql – 写特殊符号时postgres sql错误

发布时间：2020-12-13 15:52:21 所属栏目：百科来源：网络整理

导读：当我尝试将这两个单词写入 postgresql时,我收到了错误 Metro? Logic的 ERROR: invalid byte sequence for encoding "UTF8": 0xa0HINT: This error can also happen if the byte sequence does not match the encoding expected by the server,which is contr

当我尝试将这两个单词写入 postgresql时,我收到了错误

Metro?
Logic的

ERROR:  invalid byte sequence for encoding "UTF8": 0xa0
HINT:  This error can also happen if the byte sequence does not match the encoding expected by the server,which is controlled by "client_encoding".

ERROR:  invalid byte sequence for encoding "UTF8": 0x92
HINT:  This error can also happen if the byte sequence does not match the encoding expected by the server,which is controlled by "client_encoding".

解决方法

您对输入的编码不是UTF-8.如果我用例如在psql中插入ISO-8859-1文件,我可以重现这种行为. 您应该更改输入编码.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!