char nchar vchar nvchar !?

Hello
in MS SQL 2000 for text it is possible ti use
char
nchar
varchar
nvarchar
what must be used and for what ?
I want to store normal text with occidental char (accents)
thank youHello
in MS SQL 2000 for text it is possible ti use
char
nchar
varchar
nvarchar

what must be used and for what ?
I want to store normal text with occidental char (accents)

thank you
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).

See this-
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.
Joydeep|||then nvarchar seems the best for my needs

thank you|||You would be well-served by reviewing descriptions of the different datatypes in Books Online.|||yes i found it

thank you