[Building Sakai] Strange issue with non latin-1 characters in text editor

[Matthew Jones]

Your Oracle 'should' be setup okay for non-asian characters. [1] The install
guide recommends 'AL32UTF8' [2] and that's what we've got at Michigan.

You might want to check the URIEncoding on the tomcat connector in the
server.xml (for whatever connector you're using), which isn't set to UTF-8
by default. [3]  This seems like it would fix it for the editor, but you'd
still have problems in fields that don't have an fckeditor in them (like
titles and such).

[1] http://download.oracle.com/docs/cd/B10500_01/server.920/a96529/ch2.htm
[2]
https://confluence.sakaiproject.org/display/DOC/Sakai+CLE+2.8+database+support
[3] https://confluence.sakaiproject.org/display/I18N/Common+UTF-8+Problems

-Matthew

On Wed, Aug 3, 2011 at 9:34 AM, Chris Ribble <cribble at uwindsor.ca> wrote:

> Hi everyone,
>
> We recently encountered an issue in our Sakai instance that has us
> scratching our heads. Not so much at the issue itself, but at the idea that
> we had not noticed it before. When editing a text based lesson in the Melete
> tool, composing a resource using the text editor or any use of the text
> editor(FCK Editor in our case), if you entered non latin-1 characters into
> the text editor, the next time you went to view your text the non latin-1
> characters would become question marks. This caused a variety of formatting
> issues that seemed to go unnoticed for a while in our system. After much
> investigation we fixed it by changing the configuration of FCK Editor and
> using "FCKConfig.ProcessNumericEntities = true".
>
> I wanted to ask the community if anyone else had ran into this problem or
> whether anyone could shed some light on possible causes to this issue? Is it
> possible that we have the wrong character set in our database?
>
> Here is some additional information about our setup that might help:
>
> Oracle 10g database with NLS_CHARACTERSET = 'WE8ISO8859P1',
> Happens in both Sakai 2.7.1 and 2.5.2
> Using FCKEditor 2.6.4.1
>
>
> Thanks in advance,
> Chris
>
>
> Chris Ribble
> LMS Application Developer
> Information Technology Services
> University of Windsor
> 519-253-3000 x4412
> cribble at uwindsor.ca
> _______________________________________________
> 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"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110803/31a37821/attachment.html