Re: Varchar(1) or char(1) (WAS) Re: How insert new field in between?

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Fri, 24 Aug 2001 10:45:06 GMT
Message-ID: <3b862dc9.3208654@news>

On Fri, 24 Aug 2001 03:52:04 GMT, "amd" <amd_at_ck.com> wrote:

>this, but I think I have read somewhere that while comparing a char field a
>padded comparison is made while comparing a varchar2 field a non-padded
>comparison is made.
>
>How far is that true ??

Quite true and the source of much teeth gnashing during testing... One of the usual SQL traps.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Fri Aug 24 2001 - 05:45:06 CDT

This message: [ Message body ]
Next message: Nuno Souto: "Re: Analyze schema, how to unanalyze it? It is halting the database.."
Previous message: Sybrand Bakker: "Re: Problem moving a table to another tablespace (NOT a newbie)"
In reply to: amd: "Re: Varchar(1) or char(1) (WAS) Re: How insert new field in between?"
Next in thread: Connor McDonald: "Re: Varchar(1) or char(1) (WAS) Re: How insert new field in between?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US