And I would split that off into a "Text" table. Stear clear of ntext and
nvarchar unless you have a specific need for them and if you are wondering
when you would need them, you probably don't need them :-)
Mike
> -----Original Message-----
> From: Brendan Avery [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 31, 2004 8:45 PM
> To: CF-Talk
> Subject: RE: [ MSSQL ] which datatype is best for storing web
> page data
>
> Text prolly. Varchars limit is 8000 chars if I recall.
>
> -----Original Message-----
> From: Dan Farmer [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 31, 2004 3:28 PM
> To: CF-Talk
> Subject: [ MSSQL ] which datatype is best for storing web page data
>
> I have a CMS that stores the web page code into a MSSQL database.
>
> Which datatype would be best for this? ( text, ntext, nvarchar ) ?
>
> __________________________________
> Daniel Farmer
> Producer / Coldfusion Developer
> http://www.bernardclark.com/danfarmer.ca
> P: 613.284.1684
> ________________________________
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
