On 2022-09-05 11:14 AM, Martin Simmons wrote: ...
I think you need convert_from(), not encode(). Something like select convert_from(VolumeName::bytea, 'SQL_ASCII') from media;
Right, I saw the starting '\x' and looked no further. OP will have to figure out what encoding that POS is actually dumping into -- keeping in mind that it may be the OS messing it up when saving to text file -- and then figure out the right spell to un$#@! it.
Dima _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users