[Building Sakai] truncating to fit field

[Steve Swinsburg]

The field is declared wrong, if it's going to store utf8 but use substrb or
substrc to trim the string in bytes or utf8 chars.

Cheers
Steve

sent from my mobile device
On 28/02/2014 3:29 AM, "Charles Hedrick" <hedrick at rutgers.edu> wrote:

> I am generating a group name. The maximum length is 99 characters. In
> mysql it appears that truncating to 99 characters is fine, because mysql
> interprets field lengths in characters.
>
> However in Oracle, unless the declaration uses "char", it is understood to
> be bytes. That means that UTF-8 characters can take more than one space. Is
> there some standard method in Sakai to truncate a string to a length that
> will fit into a given database field?
>
> Unfortunately, the SAKAI_SITE_GROUP is defined in oracle using field names
> without "char" after them.
>
>
> _______________________________________________
> 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/20140228/885e339d/attachment.html