Re: What's this...varchar2 as fast as char?

Gert Rijs wrote:
>
> Alvin,
> Perhaps you can 'fool' your c-programs by letting them select from views:
> create view varchar_view as
> select rtrim(col) as colname
> from original_table;
>
> hope this helps,
> Gert

Thanks, but I'm afraid I'll have to add this to the list of ideas that involve either breaking the code or breaking the schema. We can't break the schema without agreement from our corporate partners, who've already shown reluctance.

Otherwise, it's a good idea.

It looks like we're going to have to break the code anyway: we're already running into situations where bugs are cropping up in unexpected places, where an "rtrim(column)" would fix. Such as, haveing a column called "longshortflag" which could either be "LONG" or "SHORT", and obviously the "strcmp" that worked in Sybase will not work in Oracle.

So it ends up freeing a node from the wrong linked list, causing all =sorts= of problems!!

-- 
+----------------------+---------------------------------------------+
| Alvin Sylvain        | Your freedom of speech doesn't mean an      |
| alvin_at_c-square.com   | obligation to listen.  Mine, however, does! |
| PLEASE! NO JUNK E-MAIL!  NO E-MAIL SOLICITATIONS!!  NO SPAM!!      |
+--------------------------------------------------------------------+