Character data consists of any combination of letters, symbols, and numeric
characters. For example, valid character data includes "928", "Johnson", and
"(0*&(%B99nh jkJ". In Microsoft? SQL ServerT 2000, character data is stored
using the char, varchar, and text data types. Use varchar when the entries
in a column vary in the number of characters they contain, but the length of
any entry does not exceeds 8 kilobytes (KB). Use char when every entry for a
column has the same fixed length (up to 8 KB). Columns of text data can be
used to store ASCII characters longer than 8 KB. For example, because HTML
documents are all ASCII characters and usually longer than 8 KB, they can be
stored in text columns in SQL Server prior to being viewed in a browser.
It is recommended that the defined length of a character column be no larger
than the maximum expected length of the character data to be stored.
To store international character data in SQL Server, use the nchar,
nvarchar, and ntext data types.
Hope that helps..
> Take a look at Northwind or Pubs database. Those could be used as a
> > Hi:
> > I'm fortunate to be designing my first SQL 2000 database. Many of the
> > I will need will contain variable length character fields such as name,
> > address and descriptions.
> > It appears to me that I should use nvarchar(size) rather than char(size)
> > all such fields since a great deal of space will be saved by this
> > (And I have found that they work fine in all programming I have done
> > my training.)
> > I would appreciate and and all comments as to whether this - or another
> > approach - is the way to go!
> > Thanks very much!
> > Fred