The difference between NTEXT and TEXT is that NTEXT supports Unicode data.
The price for this is that it takes twice as much space on your server to
store NTEXT data as it does to store TEXT data. Consequently, SQL Server
will only let you store half as much NTEXT data as TEXT data.
ColdFusion does not understand Unicode data as such so you cannot manipulate
Unicode data. Therefore, if you are working in a ColdFusion environment, you
generally gain no benefit using the NTEXT datatype as oposed to the TEXT
datatype. So, it is not that NTEXT is incompatible, but rather, an
unnecessary use of system resources. There are always exceptions, of course.
Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057
-----Original Message-----
From: Mark Warrick [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 27, 2001 1:10 PM
To: CF-Talk
Subject: RE: SQL 7.0
How is that field type incompatible with ColdFusion? I use it and it seems
to be working fine. Am I missing something here?
---mark
=========================================
Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
=========================================
-----Original Message-----
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 27, 2001 9:10 AM
To: CF-Talk
Subject: RE: SQL 7.0
> > What is the equivalent to memo in ms SQL 7.0, for the life of me my mind
> > has gone to the fairies on this one!
> Try ntext
ntext is UNICODE, and since CF4&5 aren't UNICODE compatible, this won't do
anything for you apart from eat twice the hard disk space
Until CF6/Neo comes out, it's easier to use text, varchar and the like
rather than their "N" equivalents...
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
