Subject Re: [IBO] ib_query ignores my data!
Author lester@lsces.globalnet.co.uk
> Per field setting is too much if you want always the opposite of the default.
> People that want or need to clutter 75% of the hard disk with 0x20 should be
> allowed to proceed with minimal effort.

I don't have any option but to presever the spaces. That is why I use
CHAR for that particular field. The problem is that there is an
inconsistancy somewhere that is removing spaces, and so I have to make
sure I pad back to full length if I find it wrong.

The inconsistancy in trimming things that I don't want trimmed is my
problem, and it looks as if Interbase it's self is adding to the
problem.

If CHAR and VARCHAR have the same function in the server, why not just
scrap one of them!

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services