Which ADO constant for SQL server NVarchar type?

[Iain]

Hi

I currently have the following in my adovbs.asp file:

Const adVarChar = 200
Const adLongVarChar = 201
Const adWChar = 130
Const adVarWChar = 202
Const adLongVarWChar = 203

Which of these should I use with NVarchar fields in SQL Server?

-Brian

[Bob Barrows]

Iain wrote:

> Hi
>
> I currently have the following in my adovbs.asp file:
>
> Const adVarChar = 200
> Const adLongVarChar = 201
> Const adWChar = 130
> Const adVarWChar = 202
> Const adLongVarWChar = 203
>
> Which of these should I use with NVarchar fields in SQL Server?
>
> -Brian

[url]http://www.able-consulting.com/ADODataTypeEnum.htm[/url]

You may want to try out my free stored procedure code generator available
here:
[url]http://www.thrasherwebdesign.com/index.asp?pi=links&hp=links.asp&c=&a=clear[/url]

Bob Barrows


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"