Find out encoding of data

[joynes]

Hi!
I have this problem that Im not sure if my stored data has the correct coding. When I view the data from a postgres console I just see the characters and depending on my console-encoding it looks differently.

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).

/br joynes

 

[stefanwagner]

\encoding

should show the encoding.

Perhaps

SELECT 'ü', ascii ('ü') ;

helps too.

Here are a lot of functions:
>

http://developer.postgresql.org/pgdocs/postgres/functions-string.html

don't visit my homepage:

http://home.arcor.de/hirnstrom/bewerbung