rascal
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!
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.