> "Matthias" == Matthias Apitz writes:
Matthias> Hello,
Matthias> I can SELECT && print a column in hex with:
Matthias> pos71=# select d02name::bytea from d02ben where d02bnr =
'1048313' ;
If your intention is to see the raw bytes of the stored text value, for
example to check the
## Matthias Apitz (g...@unixarea.de):
> Hmm. But *I* do need the content in hex to see if the varchar column
> contains correct encoded UTF-8 data.
select 'Hello'::bytea::text;
Regards,
Christoph
--
Spare Space
Matthias:
On Thu, Oct 10, 2019 at 7:26 PM Matthias Apitz wrote:
> Hmm. But *I* do need the content in hex to see if the varchar column
> contains correct encoded UTF-8 data. We're on the way to port a huge
> database application from Sybase to PostgreSQL and are facing any kind of
> problems one
El día jueves, octubre 10, 2019 a las 06:46:02p. m. +0200, Francisco Olarte
escribió:
> Matthias:
>
> On Thu, Oct 10, 2019 at 1:25 PM Matthias Apitz wrote:
> > I can SELECT && print a column in hex with:
> > pos71=# select d02name::bytea from d02ben where d02bnr = '1048313' ;
> > ...
> >
Matthias:
On Thu, Oct 10, 2019 at 1:25 PM Matthias Apitz wrote:
> I can SELECT && print a column in hex with:
> pos71=# select d02name::bytea from d02ben where d02bnr = '1048313' ;
> ...
> \x50c3a46461676f67697363686520486f6368736368756c65205765696e67617274656e2020
> ...
>
> but when I use
Hello,
I can SELECT && print a column in hex with:
pos71=# select d02name::bytea from d02ben where d02bnr = '1048313' ;
...
\x50c3a46461676f67697363686520486f6368736368756c65205765696e67617274656e2020
...
but when I use the same in Perl DBI::Pg with:
...
$sth=$dbh->prepare( "select d02n
