var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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?
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.
Thanks for your reply.
I have ASE 22.214.171.124 Ver. Which version supports more than 255 chars?
What version of open client are you running. Is it 126.96.36.199 as well?
I haven't used 188.8.131.52, but 12.5 allows "large" columns too.
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.