Re: LIKE operator on CHAR column when there is no wildcard character
From: gazzag <gareth_at_jamms.org>
Date: Tue, 8 Jul 2008 08:01:44 -0700 (PDT)
Message-ID: <208ddb11-6a52-43d0-9a7d-bac9fd7c1c8e@34g2000hsf.googlegroups.com>
> 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.
Date: Tue, 8 Jul 2008 08:01:44 -0700 (PDT)
Message-ID: <208ddb11-6a52-43d0-9a7d-bac9fd7c1c8e@34g2000hsf.googlegroups.com>
On 7 Jul, 16:23, William Robertson <williamr2..._at_googlemail.com>
wrote:
>
> 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.
Of course. However, that would require vendors of database-unaware software to read documentation, wouldn't it? ;)
-g Received on Tue Jul 08 2008 - 10:01:44 CDT