[Deploying Sakai] 回复: Re: problem with storing binary content on the filesystem

[Steve Swinsburg]

The nightly servers have also had the utf-8 setting added to the connector (Thanks Chris) and I can confirm that nightly trunk correctly uploads and presents a URL to the file in Chinese characters. The only issue is that on download the file name becomes the escape codes.

ie

素菜汤水.xls

becomes:

%E7%B4%A0%E8%8F%9C%E6%B1%A4%E6%B0%B4.xls

I've filed this as https://jira.sakaiproject.org/browse/SAK-21344

regards,
Steve

On 31/10/2011, at 1:40 PM, wendy lee wrote:

> Hi Steve,
>  
> I change tomcat's server.xml to include UTF-8 encoding referring to  https://confluence.sakaiproject.org/display/I18N/Common+UTF-8+Problems
> I can upload and download files with chinese filename correctly now.
> Upload filename is 素菜汤水.doc, URL is http://202.116.96.80:8080/access/content/attachment/%E7%B4%A0%E8%8F%9C%E6%B1%A4%E6%B0%B4.doc , yet the download filename is 素菜汤水.doc
> Users won't notice the flaw. Just let it be.
> Thanks Steve, Matthew Jones. Thanks all. 
>  
>  wendy lee
>  
> 发件人： Steve Swinsburg
> 发送时间： 2011-10-31 09:40
> 收件人： wendy lee
> 抄送： production
> 主题： Re: [Deploying Sakai] problem with storing binary content on the filesystem
> Hi Wendy,
> 
> Ah so the filename has the Chinese characters. Does this Jira describe what you are seeing:
> https://jira.sakaiproject.org/browse/SAK-9715
> 
> Have you enabled UTF-8 in the Tomcat connector and created your database as UTF-8?
> 
> I just created a file with Chinese characters in it, uploaded it to Sakai (2.8 nightly) and the URL was:
> http://nightly2.sakaiproject.org:8087/access/content/group/mercury/素菜汤水.xls
> 
> It downloaded ok, but the file was saved as:
> %E7%B4%A0%E8%8F%9C%E6%B1%A4%E6%B0%B4.xls
> 
> when it got to my Desktop.
> 
> That is probably another issue which I'll look in to, but I think it should work if you have your system set as UTF-8.
> 
> cheers,
> Steve
> 
> On 31/10/2011, at 12:24 PM, wendy lee wrote:
> 
>> hi Steve,
>>  
>> Nothing is reported in catalina.out.
>>  
>> The url inside sakai resource is like this:
>> http://202.116.96.80:8080/access/content/attachment/%E7%B4%A0%E8%8F%9C%E6%B1%A4%E6%B0%B4.doc
>>  
>> UI error is like:
>> HTTP Status 404 -
>> 
>> type Status report
>> message
>> description The requested resource () is not available.
>> Apache Tomcat/5.5.33
>> 
>> I try to input these urls directly into the IE,
>> those like http://202.116.96.80:8080/access/content/attachment/1001440701001002.doc or http://202.116.96.80:8080/access/content/attachment/backuplist.db is work,
>> yet those like http://202.116.96.80:8080/access/content/attachment/素菜汤水.doc orhttp://202.116.96.80:8080/access/content/attachment/%E7%B4%A0%E8%8F%9C%E6%B1%A4%E6%B0%B4.doc report 404 error. Nothing reports in catalina.out no matter what I input.
>> wendy lee
>>  
>>  
>> From: Steve Swinsburg
>> Date: 2011-10-31 08:56
>> To: wendy lee
>> CC: production
>> Subject: Re: [Deploying Sakai] problem with storing binary content on the filesystem
>> Hi,
>>  
>> What is in the catalina.out log file when you get the error? (tomcat/logs/catalina.out)
>>  
>> cheers,
>> Steve
>>  
>> On 31/10/2011, at 11:53 AM, wendy lee wrote:
>>  
>> > hi, all
>> > 
>> > I store binary content on the filesystem of CentOS. 
>> > I can upload files with filename in chinese using Resources tool. Yet it reports "HTTP Status 404" when I clicked the files.  
>> > If using files with english filename, they can be downloaded or read successfully. 
>> > I use sakai2.8, centos6.0 and tomcat5.5.33. I have set chinese supported according to the release notes of 2.8 and chinese words are display correctly in IE. 
>> > Why it happen? Thanks a lot!
>> > 
>> > --------------
>> > wendy lee
>> > 2011-10-28
>> > _______________________________________________
>> > production mailing list
>> > production at collab.sakaiproject.org
>> > http://collab.sakaiproject.org/mailman/listinfo/production
>> > 
>> > TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
> 
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20111101/608ca504/attachment.html