Truncated fields

[Liz]

Hi!

In the results of our queries, the datas in the fields are truncated to 255 chars.

Is there a parameter to change to get the entire field? Their format is varchar 8000 and the fields are longer than 255 characters in the db.

Thanks for your help.

[jason]

where are you displaying these results? if it's in query analyzer, 255 is the default length of columns in the result set, just make that bigger in your tools>options tab


------------
Liz at 4/11/01 11:50:55 AM

Hi!

In the results of our queries, the datas in the fields are truncated to 255 chars.

Is there a parameter to change to get the entire field? Their format is varchar 8000 and the fields are longer than 255 characters in the db.

Thanks for your help.

I display the results with php on web pages. So it's not a query analyzer problem.



------------
jason at 4/11/01 12:00:30 PM

where are you displaying these results? if it's in query analyzer, 255 is the default length of columns in the result set, just make that bigger in your tools>options tab


------------
Liz at 4/11/01 11:50:55 AM

Hi!

In the results of our queries, the datas in the fields are truncated to 255 chars.

Is there a parameter to change to get the entire field? Their format is varchar 8000 and the fields are longer than 255 characters in the db.

Thanks for your help.