Hi Wendy,

Thanks for spotting that - slippy fingers on my part. I'll update the JIRA 
issue comment.

Thanks,


Stuart


________________________________
From: Wendy Bossons [[email protected]]
Sent: Saturday, 14 November 2009 9:04 a.m.
To: [email protected]
Subject: Re: [Dspace-devel] [DSJ] Commented: (DS-295) CC License being assigned 
incorrect Mime Type during submission.

No objections, but the sql should be corrected to read "UTF-8", rather than 
"UTF=8".  Whereas the change will allow the license to display, the character 
encoding will be off for characters beyond the ascii character set range.

Example:
 [ 
http://jira.dspace.org/jira/browse/DS-295?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=10797#action_10797
 ]

. . .

INSERT INTO bitstreamformatregistry (bitstream_format_id, mimetype, 
short_description, description, support_level, internal) VALUES 
(nextval('bitstreamformatregistry_seq'), 'text/html; charset=utf=8', 'CC 
License', 'Item-specific Creative Commons license agreed upon to submission', 
'1', true);

UPDATE bitstream SET bitstream_format_id = (SELECT bitstream_format_id FROM 
bitstreamformatregistry WHERE short_description = 'CC License') WHERE name = 
'license_text' AND source = 'org.dspace.license.CreativeCommons';

Does anyone have any objections to this fix being applied for 1.6?

Insert should read:

INSERT INTO bitstreamformatregistry . . .  mimetype. . . l) VALUES (. . . 
'text/html; charset=utf-8' . . . );


CC License being assigned incorrect Mime Type during submission.

I am unfamiliar with "UTF=8". As far as I know it is not standardized usage. 
After running the query on my local development instance, the CC License mime 
type was corrected, but the Character set definition was incorrect. When I 
changed it to UTF-8, the issue was corrected.

..\Wendy


Wendy Bossons
Web Developer

Contact Information:
[email protected]<mailto:[email protected]>
617-253-0770






------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel

Reply via email to