Subject Re: [IBO] ib_query ignores my data!
Author Geoff Worboys

> Now that IBO allows centralized rules for domains I think it is
> easy to make either make their settings. Assuming people use
> domains, it is trivial to make a list of your domains and flag
> them with the behaviors you want for them. Trimming is included
> in that.

I dont want to define every domain in my application just to get
righttrimming applied. And it seems, from some of the other strong
opinions expressed, that others will not want to define every domain
just to prevent righttrimming.

I suggest that we may need connection or even session defaults applied
here. I guess this is already possible by using SQLType definition
(is that what you were getting at?). Although I would rather not turn
this on just for this one special case.

I also suggest that this NOT be changed in IBO v3.x. The potential
for breaking existing applications is too great. Lets leave whatever
change is decided for IBOv4.

> Because of this ease, I would like to move more towards
> mathematical correctness, written differently "don't touch
> my data!".

I would only ask that you remember back to when right trimming was
enabled. It seems to me that there were many more questions and
problems when this was not being performed. I am afraid that the
arguments for not trimming have so far only convinced me that the
number of instances where trailing whitespace is significant is very

Geoff Worboys
Telesis Computing