topic Re: share wiki - Wrong (broken) character encoding in page in Alfresco Archive

share wiki - Wrong (broken) character encoding in page

vasisualy — Thu, 01 Apr 2010 23:28:33 GMT

Hi All,I'm using Alfresco 3.2r2When I try to see detailed wiki page I got page with broken non-latin characters in the title and empty body.I'm talking about wiki page likehttp://hostname:8080/share/page/site/user/wiki-page?title=Non_Latin_test_--_%D0%94%D1%80%D1%83%D0%B3%D0%BE%D0%B9_%D0%AF%D0%B7%D1

Re: share wiki - Wrong (broken) character encoding in page

vasisualy — Sat, 03 Apr 2010 23:23:45 GMT

I thin I found way around.
If you create wiki page with only latin symbols in the title you can use cyrillic symbols in the body. And it displays Ok.

Thus IMHO non-latin title causes bug.
[img]http://img638.imageshack.us/img638/6070/screenlh.png[/img]

Hope someone who know how to paste a bug report will do it.

Re: share wiki - Wrong (broken) character encoding in page

mikeh — Sun, 04 Apr 2010 09:02:08 GMT

It's not a bug. You need to make sure your Tomcat configuration allows UTF-8 encoding. In conf/server.xml

    <Connector port="8080" protocol="HTTP/1.1" 
               connectionTimeout="20000" 
               redirectPort="8443" URIEncoding="UTF-8" />
‍‍‍‍

Thanks,
Mike

Re: share wiki - Wrong (broken) character encoding in page

vasisualy — Mon, 05 Apr 2010 22:32:39 GMT

Thank you mate.
I added proper settings and now I'm happy.

    <Connector port="8080" protocol="HTTP/1.1"
               connectionTimeout="20000"
               redirectPort="8443" URIEncoding="UTF-8" />

    <Connector port="1400" protocol="HTTP/1.1"
               connectionTimeout="20000"
               redirectPort="8443" URIEncoding="UTF-8" />

Re: share wiki - Wrong (broken) character encoding in page

jelena — Mon, 15 Nov 2010 15:50:04 GMT

I'm sorry that I bring old thread but I have a same problem with non latin signs and settings from above in server.xml haven't solved my problem.

Do you have another idea?

Tnx

Re: share wiki - Wrong (broken) character encoding in page

kevinr — Tue, 16 Nov 2010 10:38:41 GMT

Three things:
1. URIEncoding="UTF-8" in tomcat server.xml for the connector
2. UTF-8 database instance
3. ensure your my.ini for MySQL is using utf-8 for the client connection

[mysql]

default-character-set=utf8‍‍‍

Kev

Re: share wiki - Wrong (broken) character encoding in page

jelena — Tue, 16 Nov 2010 12:54:42 GMT

It was database encoding problem.

I setted these in my.cnf and it worked:


[mysqld]
default-character-set=utf8
default-collation=utf8_bin
character-set-server=utf8
collation-server=utf8_bin
init-connect='SET NAMES utf8'

[client]
default-character-set=utf8‍‍‍‍‍‍‍‍‍‍

Thanks for help

Re: share wiki - Wrong (broken) character encoding in page

kevinr — Tue, 16 Nov 2010 14:03:12 GMT

No problem!

Kev