sql server programming: Yes, that is probably going to work out best. If
there is a snow ball's chance in hell that your app
will need to store unicode characters, then nvarchar
or nchar would be a must.

--
Robbe Morris - 2004-2006 Microsoft MVP C#
I've mapped the database to .NET class properties and methods to
implement an multi-layered object oriented environment for your
data access layer. Thus, you should rarely ever have to type the words
SqlCommand, SqlDataAdapter, or SqlConnection again.
http://www.eggheadcafe.com/articles/adonet_source_code_generator.asp





[quoted text, click to view]

Hi,

I was just wondering what are the best data types to use.

Now I have used for an internet database the nvarchar datatype. Is this wise
to do for internet databases? I'm onlyse using the English, Dutch and German
language.

Other question. Now I need to change the data type of a column because I
need more that 4000 chars. I now use nvarchar. Do I now need to use ntext?

Thanks!
Arjen