Aage:

Lets look at this logically, probably in 90% of all cases most people
don't care if it gets trimmed or not. In 90% of the remaining cases
you probably want it trimmed, and if the library doesn't do it, you
end up doing it.

How about this, we ask Jason to add a pair of properties to the
Connection, that allow the programmer to select the default action.
One property for CHAR, and one property for VARCHAR. This would in
effect become a global application level setting.

Please Jason, if you read this, leave version 3 the way it is, make
this a 4.0 feature.

Paul

On 22 Mar 2001, at 20:53, Aage Johansen wrote:

To: IBObjects@yahoogroups.com
From: Aage Johansen <aagjohan@...>
Date sent: Thu, 22 Mar 2001 20:53:01 +0100
Send reply to: IBObjects@yahoogroups.com
Subject: [IBO] Re: ib_query ignores my data!

> Paul Schmidt wrote:
> ...
> I agree with your point, in the case of a VARCHAR it should remove the
> whitespace at the right, by default and in the case of a CHAR field,
> the default should be to return the field without trimming. In both
> cases this should be user modifyable to some other form of trimming.
> ... ---------------------------
>
> Remember, even a VARCHAR may have trailing (significant) spaces. Any
> trimming should be done only when explcitly asked for - IMnsHO.
>
> Regards,
> Aage J.
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-~> Do you have 128-bit SSL encryption server
> security? Get VeriSign's FREE Guide, "Securing Your Web Site for
> Business." Get it now!
> http://us.click.yahoo.com/EVNB7A/c.WCAA/bT0EAA/P0AVlB/TM
> ---------------------------------------------------------------------_
> ->
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>


Paul Schmidt,
Tricat Technologies
Email: paul@...
Website: www.tricattechnologies.com