[Building Sakai] Notes in SAKAI_PERSON_T table

[Steve Swinsburg]

And in the DB conversion scripts, it was increased to these values in  
Sakai v2.1.2->2.2.0.

For newer installs, the Hibernate mapping has it at 4000 as well:
<property name="notes" column="NOTES" length="4000" />

However, if the SQL in common-composite-component/src/sql/DB-VENDOR  
was run manually instead of using auto.ddl=true, that would have set  
it at 255:
NOTES varchar(255)

Could that be the culprit in your case?

cheers,
Steve

---
Steve Swinsburg
Portal Systems Developer
Centre for e-Science
Lancaster University
Lancaster
LA1 4YT

email: s.swinsburg at lancaster.ac.uk
phone: +44 (0) 1524 594870







On 5 Jun 2009, at 16:26, Steve Swinsburg wrote:

> Hi Omer,
>
> Notes should be a TEXT type field in MySQL and VARCHAR2(4000) in  
> Oracle, although I just found the same issue in Jira:
> http://jira.sakaiproject.org/jira/browse/SAK-6102
>
> I don't recall changing the size of the field explicitly, what  
> version Sakai?
>
> cheers,
> Steve
>
>
>
>
> On 5 Jun 2009, at 16:18, Omer Piperdi wrote:
>
>> We have a few users complain about filling 'Other' text box in  
>> Profile tool. Looks like it is back by 'Notes' column in  
>> 'SAKAI_PERSON_T' table and which is VARCHAR(255). It is too small  
>> for a WYSIWYG editor box.. Did anyone increase the size of this  
>> column in the database?
>>
>>
>> Thanks
>> Omer
>> _______________________________________________
>> 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"
>
> _______________________________________________
> 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/20090605/7d3c9202/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2437 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090605/7d3c9202/attachment.bin