[Building Sakai] wrong encoding with accents

[Miriam esteve]

Hello everyone,

I finally found the error in the configuration, simply changed the profile
of apache, export LANG = en_US.UTF-8 ---> export LANG = "en_US.UTF-8"

The problem now is that I'm using a load balancer, I think,is being encoded
in utf-8 to ISO in launching the URL, which is encoded in a strange way.

This change, the tomcat reads it and serve it, but if I go directly from the
apache  doesn't work .....

Example, the same link, * tílde.txt* file ,from Apache don't work, and from
Tomcat directly yes....



 apache ->
http://xxx.xxx.xxxx.xxx/access/content/group/67160b90-dfa8-4aee-888b-3263d5f78161/t%C3%ADlde.txt==
no


 tomcat -> http://xxx.xxx.xxxx.xxx:pppp/access/content/group/67160b90-dfa8-4aee-888b-3263d5f78161/t%C3%ADlde.txt
== yes


Moreover if we put the URL in Apache with direct conversion entity,  works
fine....

http://xxx.xxx.xxxx.xxx/access/content/group/67160b90-dfa8-4aee-888b-3263d5f78161/t%EDlde.txt==si

I think it's a bad communication of Apache and Tomcat when encoding.



I hope your help! thank you very much!

Miriam E.

2010/1/27 Nuno Fernandes <nuno at ufp.edu.pt>

> Hi Miriam,
>
> Did you specify UTF-8 as the default charset when creating the database?
> In MySQL, the create statement looks like:
>
> create database sakai default character set utf8;
>
> Also, are you using apache httpd in front of tomcat? If so, can you try
> accessing directly to tomcat?
>
> Hope it helps,
> Nuno
>
>
>  On Wed, Jan 27, 2010 at 11:31 AM, Miriam esteve <miesvesakai at gmail.com>wrote:
>
>>  Good morning to all,
>>
>> I have a problem, apparently not of Sakai (I've tested in a clean tomcat
>> -without sakai- and doesn't work) but I can't give the solution,... I hope
>> anyone has ever happened ...
>>
>> The problem comes with any tool you need to download a file containing
>> 'special chars' (accents in this case) in the title. (Resources, podcast
>> ,...)
>>
>> Does not return encoding in the URL, for example ... título.txt doesn't
>> work, but if I put in the url: ... t% EDtulo.txt  work.....
>>
>> In local, I work on windows and all works.
>>
>> In linux I have the correct locale,  also in java-Dfile.encoding = UTF8?  and
>> in the connector from server.xml....
>>
>> [root at s15381981 pruebas]# locale
>> LANG=es_ES.UTF-8
>> LC_CTYPE="es_ES.UTF-8"
>> LC_NUMERIC="es_ES.UTF-8"
>> LC_TIME="es_ES.UTF-8"
>> LC_COLLATE="es_ES.UTF-8"
>> LC_MONETARY="es_ES.UTF-8"
>> LC_MESSAGES="es_ES.UTF-8"
>> LC_PAPER="es_ES.UTF-8"
>> LC_NAME="es_ES.UTF-8"
>> LC_ADDRESS="es_ES.UTF-8"
>> LC_TELEPHONE="es_ES.UTF-8"
>> LC_MEASUREMENT="es_ES.UTF-8"
>> LC_IDENTIFICATION="es_ES.UTF-8"
>> LC
>>
>> [root at s15381981 ROOT]# locale charmap
>> UTF-8
>>
>> Fail some configuration?
>>
>> Thank you very much.
>>
>> Greetings
>>
>>
>> Miriam Esteve.
>>
>> _______________________________________________
>> sakai-dev mailing list
>> sakai-dev at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>
>> TO UNSUBSCRIBE: send email to
>> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>> "unsubscribe"
>>
>
>
>
> --
> Nuno Fernandes
>
> Profile    | http://facebook.com/nfgrilo | http://linkedin.com/in/nfgrilo
> Web      | http://codingwithcoffee.com | http://twitter.com/nfgrilo
> Work     | Analyst/Programmer @ UFP-UV [http://elearning.ufp.pt]
>              | Analyst/Programmer @ Sakai Foundation [
> http://sakaiproject.org]
>              | Sakai Fellow 2008 @ Sakai Foundation [
> http://confluence.sakaiproject.org//x/6oCTAQ]
> Address | Universidade Fernando Pessoa  [http://www.ufp.pt]
>              | Praça 9 de Abril, 349    | 4249-004 Porto
>              | tel: + 351 22 507 13 00 | fax: + 351 22 550 82 69
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100128/f9e153a1/attachment.html