Problems with ntext, nvarchar

From: Lynn (runningwiththewolves_at_hotmail.com)
Date: 02/25/04 

Date: 25 Feb 2004 10:26:37 -0800

Hi there,
I am having problems in my ASP code (ADO) getting any data of type
ntext or nvarchar from the database. It just appears blank. Having
done some research I found that you must retrieve the ntext, nvarchar
types of data at the end of the SELECT statement and then all is well.
I did this and it works fine. However I need to resolve this problem
properly.

Is there any patch which gets around this problem? I am running SQL
SERVER 2000 and I find it hard to imagine its not already fixed.

Thanks in advance,
Lynn

Relevant Pages

  • ADO problems with ntext, nvarchars
    ... Having problems with ADO returning nothing from table fields of type ... ntext and nvarchar. ... and don't be so blindly stupid etc etc etc, ...
    (microsoft.public.sqlserver.programming)
  • Speed problem with mssql 2000 and ado
    ... We are evaluating ado with delphi 7. ... Our application uses the bde to connect ... Now we are using nvarchar and ntext in our mssql database ...
    (borland.public.delphi.database.ado)
  • nText field not displaying (ASP)
    ... I changed the datatype of a field in a SQL Server 2000 database from ... However once I changed the datatype of "Body" from nvarchar to ntext, ...
    (microsoft.public.data.ado)
  • ntext field not showing up (ASP)
    ... I changed the datatype of a field in a SQL Server 2000 database from ... However once I changed the datatype of "Body" from nvarchar to ntext, ...
    (microsoft.public.inetserver.asp.db)
  • nText field not showing up (ASP)
    ... I changed the datatype of a field in a SQL Server 2000 database from ... However once I changed the datatype of "Body" from nvarchar to ntext, ...
    (microsoft.public.inetserver.asp.general)