Re: Find out encoding of data - Mailing list pgsql-general

From joynes
Subject Re: Find out encoding of data
Date
Msg-id 12995704.post@talk.nabble.com
Whole thread Raw
In response to Re: Find out encoding of data  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Responses Re: Find out encoding of data
List pgsql-general
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 read the documentation for 'decode' it tells that it just decodes
binary strings encoded with 'encode'.
How did you get that result from running decode?


/br joynes
--
View this message in context: http://www.nabble.com/Find-out-encoding-of-data-tf4549554.html#a12995704
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Goboxe
Date:
Subject: Re: Partitioned table limitation
Next
From: Nasby Jim
Date:
Subject: pgcrypto digest_exists replacement?