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

[Eliezer E Chávez]

Sorry for the misunderstanding, but i'm a support consultant too, so, i
dislike others selling me... :-)

Ok, as a clarification, and in spanish:

Creé una plantilla de autorespuesta en español, pero cuando intento crear un
nuevo ticket y RT intenta guardar el mensaje en la base de datos se queja de
los caracteres latinos (á, é, ñ, etc...)

Cómo hago para corregir eso, defino la base de datos en ISO-8859-1 (LATIN1)
ó como hago para decirle a RT como enviar la codificación a PostgreSQL.

Saludos y mis disculpas de nuevo.

EC


2010/1/11 Luis E. <lem at itverx.com.ve>

> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20100111/7b962fb7/attachment.htm>