| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: SQL Humor
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
![]() |
![]() |