Link to home
Start Free TrialLog in
Avatar of rascal
rascalFlag for United States of America

asked on

How to convert an ntext field to text when reading from the DB?

We are reading a SQL Server 2000 database and writing its contents out to a text file via our ASP web page.

The problem is that because the fields are defined as ntext, the resulting file is written out as unicode (we're just using the Scripting.FileSystemObject to create a text file and it appears to automatically be saving it as a unicode file).

This is a problem because the 3rd party system we send the text file off to cannot process the unicode data.

QUESTION: Is there a function we can use in our SQL query to have SQL convert the ntext field to text so that the resulting string from the recordset is a non-unicode string?

Thanks experts!
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial