nText and nVarChar. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

nText and nVarChar.

Author

Topic

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2007-02-06 : 13:51:33

Hello,

I need to save some news text in an SQL table. The text can be long.
1. Should I use nvarchar(MAX) or nText?
2. And what is the difference between nText and Text?

I am using SQL 2005.

Thanks,
Miguel

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-02-06 : 13:53:40

Have you checked SQL Server Books Online to determine what the difference is?

Tara Kizer

X002548
Not Just a Number

15586 Posts

Posted - 2007-02-06 : 13:57:42

I can't resist

It's Manual

Why do they keep text around..backward compatability?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-02-06 : 17:16:05

quote:
Originally posted by X002548
Why do they keep text around..backward compatability?

yes.

www.elsasoft.org

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-02-06 : 17:20:29

use nvarchar(max) and varchar(max) over ntext/text. the latter are deprecated:

http://msdn2.microsoft.com/en-us/library/ms143729.aspx

the "n" versions are for unicode. no reason to use them unless you have non-ansi strings.

www.elsasoft.org

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources