Re: Find out encoding of data

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "joynes *EXTERN*" <joynes(at)hotmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Find out encoding of data
Date: 2007-10-02 07:13:39
Message-ID: D960CB61B694CF459DCFB4B0128514C2443A87@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

joynes wrote:
> What I really want to see is the hexadecimal or octal value
> of the bytes of the retrieved data. Can postgres give me
> this somehow (without exporting tables to files and look at
> the files).

Maybe 'decode' can help you:

test=> SELECT decode('10EUR', 'escape');
decode
----------------
10\342\202\254
(1 row)

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2007-10-02 07:30:25 Re: how to ignore invalid byte sequence for encoding without using sql_ascii?
Previous Message Jason L. Buberel 2007-10-02 05:32:14 Re: Strange discrepancy in query performance...