Varchar larger that 255 in SQL 2000 1

[tmp14]

SQL Server 2000 allows varchar greater than 255, however I am unable to return more that 255 in the select statement. I have verified that the table does accept and store the larger field size. Does anyone know how to return the full field on the select statement.

Traci

 

[rajeevnandanmishra]

Hi traci,
If you are using analyzer tool, Just make sure that the no. of characters per row should be set up as per your requirement.

And if, you are using any other tool to retrieve the data then please specify it.

 

[tlbroadbent]

Issue this command.

SET TEXTSIZE 2048

Sets the max number of characters returned at 2048. Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[puppet]

I Have the same problem in SQL 7 and cannot seem to get Query analyzer to return more than 255 characters. How do I use SET TEXTSIZE - it does not seem to affect anything??

 

[cbeggan]

Just had the same issue... Seems to be a Query Analyser display issue. Assuming you are using the Query analyser, you need to go to the Tools Menu, Select Options and the Results tab and set the maximum characters from 256 per column to a larger value.

This is probably a bit late for you, but may help someone! ------
Dublin, Ireland.

 

[traveller4]

You could use:

SELECT
CAST([Your Field Name]as varchar(500))
FROM [Your Table Name]

Note: The Maximum for SQL 2000 is 8000 characters