Re: SQL Humor
From: Mikito Harakiri <mikharakiri_nospaum_at_yahoo.com>
Date: 18 Aug 2005 11:44:32 -0700
Message-ID: <1124390672.631946.49660_at_z14g2000cwz.googlegroups.com>
Date: 18 Aug 2005 11:44:32 -0700
Message-ID: <1124390672.631946.49660_at_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 - 20:44:32 CEST