3
Contributors
3
Replies
5
Views
9 Years
Discussion Span
Last Post by hollystyles
0

Prior to Sql Server 2005 it would have been text or nText (the n prefix is for unicode data as opposed to ASCII data) as varchar is limited to approx 8000 chars (the max length of a row allowed and if you use it all for one varchar column you got no space left for anymore) Text fields require a little extra work in your Sql statements though :(

If you mean Sql Server 2005 Express then your options are better :)
varchar(max) (non-unicode ASCII chars only)
nvarchar(max) (Unicode chars)
text
nText

I recommend varchar or nvarchar. If your data is all in plain english (no special chracter sets) then varchar(max) is your baby

0

Does this answer apply to data types in MS SQL Server 7, also?

I'm coming from the world of MS Access and memo data type.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.