[rt-users] Problems with rt 3.8.7/postgresql 8.4.2 encoding

[Luis E. Muñoz]

On Mon, 2010-01-11 at 07:24 -0430, Eliezer E Chávez wrote:
> Hi Luis:
> 
> Disregarding the fact that you're selling me support in this list,
> [...]

Sorry, you're wrong. I answered in a *private* message, in spanish BTW,
because you mentioned in your message that you're from Venezuela and
that your English had room for improvement.

In that private message, I pointed some things to look at and yes, let
you know that we offer professional services that might be of interest.
Again, this was outside the regular list traffic.

As an exercise, think about who violated etiquette by posting a private
message on a public forum now.

> I already know that the problem is that i've created an autoresponse
> template in spanish with ascii characters that are not recognized in
> unicode format.

Good. That paragraph does not mean what you think it does. A text
composed entirely of ASCII characters, is valid UTF-8 (UTF-8 and Unicode
are not synonyms, ASCII is just one of many possible encodings).

Your problem seems to be related to a chain of encoding/decoding
operations in which at least one of them is interpreting a string
assuming the wrong encoding.

> What i want to know is how i solve this issue in PostgreSQL, cuz in
> Oracle 10gR2 dosn't happen...

Your problem is not with PostgreSQL, which is doing the right thing.
You're feeding it a string of badly encoded UTF-8. Check your
environment and make sure you're doing everything with UTF-8 so that the
encodings are consistent. IOW, follow the advice you Cc-ed to the list.

Best regards.

-lem