Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2002
    Location
    Caracas-Venezuela
    Posts
    4

    Unanswered: insert arrays in SQLServer

    Hi, im trying to insert an array which length is 2048 numbers. Ive had some problems because the ASP display that the field maximun length its 128.
    I defined the type of the field (in SQLserver 2000): varchar 2048. I dont know if that is the right type field for this array?

    Thanks

  2. #2
    Join Date
    Aug 2002
    Posts
    5
    Use ntext. I beleive varchar has 1024 limit.

  3. #3
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    According to BOL the max length for varchar is 8000 bytes. nvarchar has a limit of 4000 bytes. text has a limit of 2^32 bytes. ntest has a limit of 2^30 bytes

    The question is what is the data type and storeage size for the attribute you are using? varchar(128) maybe?
    Paul Young
    (Knowledge is power! Get some!)

  4. #4
    Join Date
    Aug 2002
    Location
    Caracas-Venezuela
    Posts
    4
    Thanks for answering me.
    the data type that im using is a varchar, and the side that i asignated was 2048.

Posting Permissions

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