PostgreSQL error: converted to the required encoding

Question

I am trying to update a column:

update t_references
set    reference = 'St&#246;cker W, et al. Autoimmunity to Pancreatic Juice in Crohn&#8217;s Disease. 
    Results of an Autoantibody Screening in Patients With Chronic Inﬂammatory Bowel Disease. <i>Scand J Gastroenterol Suppl</i>. 1987;139:41-52.'
      ,index = 9
where  reference_id = 161;

I got error:

The query could not be converted to the required encoding.

Please advise.

I had to login to the machine and then ran this from the command.

What is the definition of the table as shown by the psql's \d command? — vyegorov
– vyegorov, Commented Apr 25, 2012 at 17:57
This message is produced by pgadmin, not by postgresql. Also the update statement itself seems dubious anyway: no doubling or escaping of the single quote (Crohn's), no WHERE clause. — Daniel Vérité
– Daniel Vérité, Commented Apr 25, 2012 at 18:23
As @Daniel mentioned, the error msg comes from pgAdmin. To be precise from pgQueryThread.cpp. I have never had this error though. — Erwin Brandstetter
– Erwin Brandstetter, Commented Apr 25, 2012 at 23:07

FergusK · Accepted Answer · 2012-05-04 10:38:14Z

1

On experiencing the same error, I found I could recreate it when opening a .SQL file saved from PGAdmin in an editor(even Notepad) and then copying and pasting the contents into PGAdmin. When I opened the file directly with PGAdmin, there was no issue.

HTH

answered May 4, 2012 at 10:38

FergusK

111 bronze badge

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL error: converted to the required encoding

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related