[Using Sakai] Wrong character encoding

[David Horwitz]

Hi Fernando,

There are 2 places that I know from that your encoding can go wrong -
either in the database or the tomcat transmission of the data.

If your using mysql you will want to have utf8 as the default table
character set:

create database Sakai default character set 'utf8';

And you want your front end you also want uft8 encoding. Make sure your
tomcat connector definitions include utf8:

!-- Define a non-SSL HTTP/1.1 Connector on port 8080 -->
    <Connector port="8080" maxHttpHeaderSize="8192"
               maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
               enableLookups="false" redirectPort="8443" acceptCount="100"
               connectionTimeout="20000" disableUploadTimeout="true"
URIEncoding="UTF-8"/>


You also want to check your loadbalancer (be it apache or something
else) if your using one.

Regards

David



On 03/25/2010 01:51 PM, Fernando Carletti wrote:
> Hello!
>
> I'm getting a problem while displaying some special characters.
> My language is set to pt_BR, some string are displayed correctly, but some aren't.
>
> See the attatchment.
>
> How can I solve this problem?
>
> Thank you!
>
> Fernando Carlétti
> Administrador de Banco de Dados
> Núcleo de Computação e Tecnologia
> Fone: 28 3526-5929 - Fax: 28 3526-5934
> Acesse: www.saocamilo-es.br<http://www.saocamilo-es.br/>
>
> [cid:image001.jpg at 01CACBF5.6D915EB0]
>
>
>
>
>   
>
>
> _______________________________________________
> sakai-user mailing list
> sakai-user at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>
> TO UNSUBSCRIBE: send email to sakai-user-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20100325/ae64b9bb/attachment.html