Yeah you're right.
I didnt test it with any special characters. It works when I do :)
Thx a lot!
--
View this message in context:
http://www.nabble.com/Find-out-encoding-of-data-tf4549554.html#a13014617
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
joynes wrote:
> This doesnt work for me but it is exactly what I want. When I run your
> example I just get:
>
> >SELECT decode('10EUR', 'escape');
> decode
>
> 10EUR
> (1 rad)
>
> I get the same result, both if the database is UTF8 or
> ISO-Latin1 and also
> with different versions
Hi!
This doesnt work for me but it is exactly what I want. When I run your
example I just get:
>SELECT decode('10EUR', 'escape');
decode
10EUR
(1 rad)
I get the same result, both if the database is UTF8 or ISO-Latin1 and also
with different versions of postgres (7 and 8)
And when I
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
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 ret
