0

I have encoded values in the table, and wanted to select them as a plain text without altering the database property,

I have tried many ways, but not getting exact result.

Value - Er tręäńgt keinen Manteł Expected - Er treangt keinen Mantel

SELECT 'Er tręäńgt keinen Manteł', 'Er tręäńgt keinen Manteł'::bytea;
SELECT 'Er tręäńgt keinen Manteł', convert_to('Er tręäńgt keinen Manteł', 'utf-8');

Any suggestion will be helpful.

John Rotenstein
  • 241,921
  • 22
  • 380
  • 470
Jim Macaulay
  • 4,709
  • 4
  • 28
  • 53

0 Answers0