[Building Sakai] wrong encoding with accents

[Nuno Fernandes]

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/20100127/9c39adf9/attachment.html