[Building Sakai] truncating to fit field

[Steve Swinsburg]

I just saw that same piece of code. Seems like unnecessary work that
everything will need to implement when the column itself could just be
changed quite safely.

Though it does sound like you are writing to the group table directly when
it should be using the api?

Cheers
Steve

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

> my new code uses this: https://gist.github.com/lpar/1031951, except for
> mysql, where a substring will do (because it interprets limits as
> characters, not bytes).
>
> Yuck.
>
> This is LSNBLDR-352.
>
> On Feb 27, 2014, at 3:54 PM, Steve Swinsburg <steve.swinsburg at gmail.com>
> wrote:
>
> 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/fd81fd39/attachment.html