Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2010
    Posts
    25

    Unanswered: Datatype to store more than 255 characters

    HI,
    Some time more then 255 character long value is being passed to one of the parameter of my stored proc whose data type is VARCHAR(255).
    This results into error.

    Is there any other datatype that I can use to avoid this discrepancy or any other alternate way to deal with this error?

    I am using Sybase ASE 12.5 version.

    Pls advise..
    Thanks

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    How much bigger do you need? will varchar(1000) do?
    There is a text data type but it creates other problems

  3. #3
    Join Date
    Jan 2010
    Posts
    25
    Hi pdreyer,
    thanks for replying.
    varchar(1000) will be much better then 255. Can you let me know how can i use text datatype. Somewhere I heard text datatypes cannot be used as a variable or parameter.

  4. #4
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    You can go up to varchar(16384)
    For tables it depends on your page size

Posting Permissions

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