{"id":351,"date":"2009-11-28T06:44:46","date_gmt":"2009-11-28T10:44:46","guid":{"rendered":"http:\/\/linuxhostingsupport.net\/blog\/?p=351"},"modified":"2013-03-30T06:49:38","modified_gmt":"2013-03-30T10:49:38","slug":"invalid-byte-sequence-for-encoding-utf8","status":"publish","type":"post","link":"https:\/\/linuxhostingsupport.net\/blog\/invalid-byte-sequence-for-encoding-utf8","title":{"rendered":"invalid byte sequence for encoding “UTF8”"},"content":{"rendered":"

Error:<\/strong><\/p>\n

root@host [~]#\u00a0 psql databasename < dump.sql<\/strong><\/span><\/p>\n

ERROR:\u00a0 invalid byte sequence for encoding “UTF8”: 0xd1e9
\nHINT:\u00a0 This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by “client_encoding”.<\/strong><\/span><\/p><\/blockquote>\n

The above error is received while restoring a pgsql dump and when the clicnt_encoding of the database is mismatched.<\/p>\n

Solution:<\/strong><\/p>\n

1) Edit the dump.sql file<\/strong><\/p>\n

vi dump.sql<\/span><\/strong><\/p><\/blockquote>\n

2) Change the line<\/strong><\/p>\n

SET client_encoding = ‘SQL_ASCII’;<\/strong><\/span><\/p>\n

to<\/strong><\/span><\/p>\n

SET client_encoding = ‘latin-1’;<\/strong><\/span><\/p><\/blockquote>\n

i.e. you need to change the client_encoding from ‘SQL_ASCII’ to ‘latin-1’<\/span><\/strong>.<\/p>\n

3) Save the file and restore the database once again.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

Error:
\nroot@host [~]#\u00a0 psql databasename < dump.sql
\nERROR:\u00a0 invalid byte sequence for encoding “UTF8”: 0xd1e9
\nHINT:\u00a0 This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by “client_encoding”.
\nThe above error is received while restoring a pgsql dump and when the clicnt_encoding of the database is mismatched.
\nSolution:
\n1) Edit the dump.sql file
\nvi dump.sql
\n2) Change the line
\nSET client_encoding = ‘SQL_ASCII’;
\nto
\nSET client_encoding = ‘latin-1’;
\ni.e. you need to change the client_encoding from ‘SQL_ASCII’ to ‘latin-1’.
\n3) Save the file and restore the database once again.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[111],"tags":[450,457,453,455,456,449,452,454,451],"_links":{"self":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/351"}],"collection":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/comments?post=351"}],"version-history":[{"count":3,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/351\/revisions"}],"predecessor-version":[{"id":353,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/351\/revisions\/353"}],"wp:attachment":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/media?parent=351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/categories?post=351"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/tags?post=351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}