Ernesto:<br><br>Thanks for a really good clarification, and sorry for my spanish text (hehe), now i'm sending my config so you can check if i have something wrong...<br><br>1.- Apache config:<br><font size="2"><span style="font-family: courier new,monospace;"><VirtualHost *:80></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> ServerName <a href="http://rt.yv-consulting.com">rt.yv-consulting.com</a></span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> ErrorLog ...</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> CustomLog ...</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> DocumentRoot ...</span><br style="font-family: courier new,monospace;">
<br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> AddDefaultCharset UTF-8</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> PerlRequire .../<a href="http://webmux.pl">webmux.pl</a></span><br style="font-family: courier new,monospace;">
<br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> <Location ^/NoAuth/*></span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> SetHandler default-handler</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> </Location></span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> <Directory ...></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> Order allow,deny</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> Allow from all</span><br style="font-family: courier new,monospace;">
<br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> SetHandler perl-script</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> PerlResponseHandler RT::Mason</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> </Directory></span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"></VirtualHost></span></font><br>
<br>2.- PostgreSQL DB<br><span style="font-family: courier new,monospace;"> List of databases</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> Name | Owner | Encoding | Collation | Ctype | Access privileges</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">-----------+----------+----------+-------------+-------------+-----------------------</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">...</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> rt | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">...</span><br style="font-family: courier new,monospace;">
<br>If you need any other file, pls let me know and THANK YOU ALL FOR YOUR HELP!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!<br><br>Best Regards,<br><br>EC<br><br><div class="gmail_quote">2010/1/11 Ernesto Hernández-Novich <span dir="ltr"><<a href="mailto:emhnemhn@gmail.com">emhnemhn@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="im">On Mon, 2010-01-11 at 08:07 -0430, Eliezer E Chávez wrote:<br>
> Sorry for the misunderstanding, but i'm a support consultant too, so,<br>
> i dislike others selling me... :-)<br>
><br>
> Ok, as a clarification, and in spanish:<br>
<br>
</div>I believe this list requests messages to be written in english.<br>
<div class="im"><br>
> Creé una plantilla de autorespuesta en español, pero cuando intento<br>
> crear un nuevo ticket y RT intenta guardar el mensaje en la base de<br>
> datos se queja de los caracteres latinos (á, é, ñ, etc...)<br>
<br>
</div>Translation and edition by me, for the non spanish reading readers:<br>
<br>
"I created an autoresponse template in spanish. If I try to create a new<br>
ticket, when RT tries to store the message in the database, it complains<br>
on the latin characters (a acute, e acute, n tilde, etc.).<br>
<br>
How do I fix that? Shall I define the database as ISO-8859-1 (LATIN1)?<br>
How do I get RT to tell PostgreSQL the encoding?<br>
<br>
Regards and apologies."<br>
<br>
Looking at the couple of traces you've sent, you have a typical<br>
re-encoding problem others have hinted about. Since 0xc361 starts with<br>
character 0xC3 (Ã) and that one is the first one in the two-byte<br>
sequences for many UTF-8 encodings, finding out that 0xC361 was meant to<br>
be an 'á' (a acute) is trivial. Therefore, it's clear to me that<br>
something went from proper UTF-8 into ISO-8559-X but then was<br>
incorrectly interpreted back as UTF-8. And by incorrectly I don't mean<br>
the software made a mistake, but that it's improperly configured<br>
(encoding detection isn't automatic, and it's hard even for most alert<br>
humans).<br>
<br>
You should verify that you're working with UTF-8 end-to-end. This means<br>
checking that Apache2 is serving UTF-8 and accepting UTF-8, and also<br>
keep PostgreSQL using UTF-8 as database encoding. It also means that the<br>
data YOU input is also in UTF-8, meaning your browser has a sane<br>
configuration and the operating system it runs on can work with UTF-8.<br>
<br>
I'm guessing you wrote the template using a browser that was working on<br>
UTF-8, but Apache was expecting ISO-8859 either because the browser said<br>
it was going to provide ISO-8859 or because Apache has a (wrongly)<br>
forced default charset. That caused the properly formed 'á' (one char,<br>
two bytes, UTF-8) coming from the browser to be transformed by Apache<br>
into 'Ãa' (two chars, two bytes, ISO-8859), and then when that was fed<br>
to PostgreSQL turned out as an error because it's not proper UTF-8.<br>
<br>
BTW, you mentioned that Oracle did not complain. It doesn't complain<br>
because it's dangerously permissive. It just gobbled whatever you gave<br>
it without checking. Been there, done that, it's very very sad.<br>
<br>
So, don't change Pg to ISO-8859-1. Make sure the browser, the OS it's<br>
running on and Apache are working in UTF-8 all the way.<br>
--<br>
Ernesto Hernández-Novich - Linux 2.6.28 i686 - Unix: Live free or die!<br>
Geek by nature, Linux by choice, Debian of course.<br>
If you can't aptitude it, it isn't useful or doesn't exist.<br>
GPG Key Fingerprint = 438C 49A2 A8C7 E7D7 1500 C507 96D6 A3D6 2F4C 85E3<br>
<br>
<br>
_______________________________________________<br>
<a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users" target="_blank">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>
<br>
Community help: <a href="http://wiki.bestpractical.com" target="_blank">http://wiki.bestpractical.com</a><br>
Commercial support: <a href="mailto:sales@bestpractical.com">sales@bestpractical.com</a><br>
<br>
<br>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>
Buy a copy at <a href="http://rtbook.bestpractical.com" target="_blank">http://rtbook.bestpractical.com</a></blockquote></div><br>