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

[Chris Ribble]

Thanks for the suggestions Matthew. I've double checked our tomcat 
connector, it is set to UTF-8. It must be our DB character set then.

Thanks again,
Chris




From:   Matthew Jones <jonespm at umich.edu>
To:     Chris Ribble <cribble at uwindsor.ca>
Cc:     sakai-dev at collab.sakaiproject.org
Date:   08/03/2011 09:44 AM
Subject:        Re: [Building Sakai] Strange issue with non latin-1 
characters in text editor
Sent by:        jonespm at gmail.com



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/5b6fb84e/attachment.html