Professional Web Applications Themes

Which ADO constant for SQL server NVarchar type? - ASP Database

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...

  1. #1

    Default Which ADO constant for SQL server NVarchar type?

    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


    Iain Guest

  2. #2

    Default Re: Which ADO constant for SQL server NVarchar type?

    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"


    Bob Barrows Guest

Similar Threads

  1. Mimic Input Type=File server to server
    By garbagecatcher in forum ASP
    Replies: 8
    Last Post: June 22nd, 08:42 PM
  2. Adding numbers from a nvarchar field
    By JayG in forum ASP Database
    Replies: 4
    Last Post: January 22nd, 02:39 PM
  3. Replies: 3
    Last Post: October 18th, 06:56 AM
  4. Replies: 2
    Last Post: October 16th, 08:29 AM
  5. nvarchar Question
    By Don Grover in forum ASP
    Replies: 1
    Last Post: October 11th, 01:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139