Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2002
    Posts
    29

    Unanswered: col lenth of 255??

    I have 3 columns as varchar(255). All the three columns are completly filled. When I write the following concatinated select query, it gives only 255 char output.

    select rtrim(col1)+rtrim(col2)+rtrim(col3) from tmp

    Do you guys know why is that?. Is this sybase (SQL) restriction that length of each output column is max 255?

    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    Germany, near Aachen
    Posts
    120
    You try to concatenate three strings of 255 chars length together.
    The max stringlength is 255, so the new string will be truncated.

    Either try: select rtrim(col1), rtrim(col2), rtrim(col3) from tmp
    if possible or upgrade your ASE Version.

  3. #3
    Join Date
    Oct 2002
    Posts
    29
    Thanks for your reply.

    I have ASE 12.0.0.5 Ver. Which version supports more than 255 chars?

    Thx.

  4. #4
    Join Date
    Sep 2002
    Location
    Hong Kong
    Posts
    159
    What version of open client are you running. Is it 12.0.0.5 as well?

    I haven't used 12.0.0.5, but 12.5 allows "large" columns too.

  5. #5
    Join Date
    Feb 2003
    Location
    Brisbane, Australia
    Posts
    110
    You may also want to check whatever you are using to retrieve the data. In others words if you are using a tool such as WinSQL or SQL Advantage they may limit the information returned. If it is within some code check the length of the variable that retrieve's the data etc.

    Just a thought.

Posting Permissions

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