Re: LIKE operator on CHAR column when there is no wildcard character
From: William Robertson <williamr2019_at_googlemail.com>
Date: Mon, 7 Jul 2008 08:23:24 -0700 (PDT)
Message-ID: <26beea6e-bd9c-435d-8e1b-499d0d04fa2c@26g2000hsk.googlegroups.com>
Date: Mon, 7 Jul 2008 08:23:24 -0700 (PDT)
Message-ID: <26beea6e-bd9c-435d-8e1b-499d0d04fa2c@26g2000hsk.googlegroups.com>
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. Received on Mon Jul 07 2008 - 10:23:24 CDT