in MS SQL 2000 for text it is possible ti use
what must be used and for what ?
I want to store normal text with occidental char (accents)
Varchar and nvarchar provide more efficient storage than char and nchar.
Text and ntext is used to store text that would be longer than 8000 characters.
You would use nchar,nvarchar and ntext only if you want to use special characters(Unicode character set).
Char - fixed no of non unicode characters -max size 8000 characters if you assign char(10) and store 7 characters in it, it will store 3 blank spaces in it.But if you use varchar(10) and do the same thing that will not happen,it will store only 7 characters.
And Unicode is a character set that is capable of displaying and storing 65,536 different characters,whereas a standard character set can store and display only 256 different characters.Unicode uses 2 bytes and is very useful for international companies.Hope this will help you.