sql - Data Type Mapping

I need to store XML data to database(MS SQL Server). The data type defined in the column is text.

I need to know the the equalent datatype for text. I have tried with adLongVarChar but it does not works. Also I tried with adLongVarWChar(nText). But both are not working.

Need help.


2 Answers

  1. Loren- Reply


    TSQL datatype for a string is varchar or nvarchar (unicode). To specify the length of the string, varchar(50).

    Also note there is an XML datatype in SS 2008 (2005?).

Leave a Reply

Your email address will not be published. Required fields are marked *

You can use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>