About the datatype size

[Dhyanga]

Hi, I am creating one table and it has field like DetailInfo. Since the user can insert short or long details, I am wondering which particular datatype with maximum size to be used ? Well nvarchar has max 5000 but is there anyway i can use more than that size ? So shall I use nText or nvarchar in this case ? thanks in advance

suchita

[PIEBALDconsult]

Which database? If Sql Server, look into nvarchar(max). :cool:

[Dhyanga]

Yes. Sql Server.

suchita

[Corporal Agarn]

Note that nText is going away in future SQL server releases. The nvarchar(max) should do what you want.

[Dhyanga]

thanks. I used nvarchar(max). just trying to know which one holds large data like 2-3 pages. i haven't worked with large data before.

suchita