Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: char vs. varchar

Re: char vs. varchar

From: Maxim A Sokolnikov <max_at_mpsb.moris.ru>
Date: Sun, 10 Jan 1999 15:05:16 +0300
Message-ID: <3698977B.22581997@mpsb.moris.ru> 







tedchyn_at_yahoo.com wrote:



> When you compare varchar2 to another varchar2 field oracle will append the


> shorter field to make two comparing fields equal length before comparison and


> this does not happen when char is compare vs a varchar2 field.





Wrong,. varchar2 stores counter byte(s) and if counters don`t equal, Oracle can make



decicion more quickly than doing byte-to-byte (char to char) compareing as in
char...



Maxim



Received on Sun Jan 10 1999 - 06:05:16 CST












Original text of this message













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