Professional Web Applications Themes

nvarchar Question - ASP

I have an asp page that updates a ms sql 2k db. If put a name in a db field of 12 characters should the nvarchar length be set to 24 to allow for double byte characters. Should I be using nvarchar or char as when i make my input field length in asp page 12 the insert fails but if i make it 3 or 4 it works ok even though the db field length is set to same as asp field length. Regards Don...

  1. #1

    Default nvarchar Question

    I have an asp page that updates a ms sql 2k db.

    If put a name in a db field of 12 characters should the nvarchar length be
    set to 24 to allow for double byte characters.

    Should I be using nvarchar or char as when i make my input field length in
    asp page 12 the insert fails but if i make it 3 or 4 it works ok even though
    the db field length is set to same as asp field length.

    Regards
    Don


    Don Grover Guest

  2. #2

    Default Re: nvarchar Question

    No - it should be set to 12. Each character takes up 2 bytes of hard disk
    space (and counts as two bytes towards the 8 kb row length limit)

    Post the error you are getting.

    Cheers
    Ken

    "Don Grover" <spamfreeassoft.com.au> wrote in message
    news:eYTrce$jDHA.2000TK2MSFTNGP12.phx.gbl...
    : I have an asp page that updates a ms sql 2k db.
    :
    : If put a name in a db field of 12 characters should the nvarchar length
    be
    : set to 24 to allow for double byte characters.
    :
    : Should I be using nvarchar or char as when i make my input field length in
    : asp page 12 the insert fails but if i make it 3 or 4 it works ok even
    though
    : the db field length is set to same as asp field length.
    :
    : Regards
    : Don
    :
    :


    Ken Schaefer Guest

Similar Threads

  1. Newbie Question: Biz Card Template Question
    By Thomas_Porter@adobeforums.com in forum Adobe Indesign Windows
    Replies: 4
    Last Post: May 30th, 08:08 AM
  2. Replies: 9
    Last Post: April 27th, 04:44 AM
  3. Adding numbers from a nvarchar field
    By JayG in forum ASP Database
    Replies: 4
    Last Post: January 22nd, 02:39 PM
  4. Which ADO constant for SQL server NVarchar type?
    By Iain in forum ASP Database
    Replies: 1
    Last Post: November 18th, 12:08 AM
  5. Pen Tool Use Question. (Embarrassingly Newbie Question)
    By Bozo Schmozo in forum Macromedia Flash
    Replies: 0
    Last Post: November 12th, 10:00 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