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

Home -> Community -> Usenet -> comp.databases.theory -> Re: SQL Humor

Re: SQL Humor

From: Mikito Harakiri <mikharakiri_nospaum_at_yahoo.com>
Date: 18 Aug 2005 11:44:32 -0700
Message-ID: <1124390672.631946.49660@z14g2000cwz.googlegroups.com>


Razvan Socol wrote:
> > there is not a single advantage of char over varchar2
>
> "varchar2" ? You seem to live in an Oracle world, but here we are MS
> SQL Server people. And in SQL Server there is an advantage for char
> over varchar: char(n) has takes two bytes less to store than
> varchar(n), if the string has always n characters.
>
> Razvan

Hmm... With todays terabytes of disc memory, are 2 extra bytes really that important? If storage size is really critical, then maybe column compression might help? Received on Thu Aug 18 2005 - 13:44:32 CDT

Original text of this message

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