MSSQL and ntext
| From: | LP | Date: | Thu, 09 Nov 2000 12:50:13 +0000 |
| Subject: | MSSQL and ntext | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-general+get-24487@lists.php.net to get a copy of this message | ||
We have an application that is currently
running in MS Access. It is a bug tracker.
We have a description and resolution field.
The max length of data in description
is 10k long and in resolution is 34k long.
We are porting the application to MSSQL
and PHP.
In MSSQL my solution for the above columns
would be to define them as 'ntext' but then
I found the following problem when I ran
my PHP script:
"MS SQL message: ntext data cannot be sent
to clients using DB-Library (such as ISQL)
or ODBC version 3.7 or earlier."
I am not using ODBC. I am using the provided
extension (Apache & NT 4).
From what I can tell there will be a lot
more coding envolved if I use ntext or text.
Does anybody have any thoughts on this?
Does anybody have another solution for
storing large amounts of text in MSSQL?
LP
__________________________________________________
Do You Yahoo!?
Thousands of Stores. Millions of Products. All in one Place.
http://shopping.yahoo.com/