CODEWITHSUNDEEP
postgresqlencodingpgadmin
Peter
Peter

Reputation: 51

PostgreSQL error: converted to the required encoding

I am trying to update a column:

update t_references
set    reference = 'Stöcker W, et al. Autoimmunity to Pancreatic Juice in Crohn’s Disease. 
    Results of an Autoantibody Screening in Patients With Chronic Inflammatory 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.

Upvotes: 0

Views: 390

Answers (1)

FergusK
FergusK

Reputation: 11

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

Upvotes: 1

Related Questions