Re: LIKE operator on CHAR column when there is no wildcard character

On Jul 7, 10:23 am, William Robertson <williamr2..._at_googlemail.com> wrote:
> On Jul 7, 2:29 pm, Veeru71 <m_ad..._at_hotmail.com> wrote:
>
> > you are right, we should have used
> > varchar2 cols instead of char cols in the first place but this is a
> > legacy app.
>
> I wonder why they used CHAR even back in those far-off legacy days.
> There has never been a good reason to use a blank-padded character
> type in any version of Oracle. This anti-feature was introduced in
> Oracle 6 for ANSI compatibility - you weren't actually expected to use
> it.

But, if it's there, it will be used ... be it daft or not.

David Fitzjarrell Received on Mon Jul 07 2008 - 14:11:13 CDT