[Building Sakai] varchar2 -> clob in Oracle for Samigo, Was: Re: Test & Quizzes 4000 character limit

[Will Humphries]

Has anyone tried changing any of the Samigo varchar2 fields to clob in 
Oracle? We've been getting complaints about the limit on short essay 
answers (sam_itemgrading_t.answertext) and that seems like what we'd 
need to do to up the limit (along with a change to the hbm and jsp's).

-Will

Karen Tsao wrote:
> Hi Sean,
>
> This limit is from Oracle's 4000 character limitation on VARCHAR2 fields.
>
> If you are using Oracle, you have to change the column type and 
> increase the validateLength in JSF files. For MySQL, because there is 
> no limit, you can just increase the length of that column and the 
> validateLength in JSF.
>
> By the way, the reason we use 4000 is to keep the behavior consistent.
>
> Thanks,
> Karen
>
> On Thu, Aug 27, 2009 at 8:32 AM, Sean Keesler 
> <sean.keesler at threecanoes.com <mailto:sean.keesler at threecanoes.com>> 
> wrote:
>
>     I see that Tests and Quizzes has a 4000 validation on many of its
>     forms. (i.e. the assessment description field, question answers
>     What is the basis for that limit?
>     It seems embedded in the code and not configurable...
>
>     Sean Keesler
>     130 Academy Street
>     Manlius, New York 13104 USA
>     315-663-7756
>     sean.keesler at threecanoes.com <mailto:sean.keesler at threecanoes.com>
>
>     _______________________________________________
>     sakai-dev mailing list
>     sakai-dev at collab.sakaiproject.org
>     <mailto: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
>     <mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a
>     subject of "unsubscribe"
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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"