SQL Server varchar(8000) being truncated to char(255) 
Author Message
 SQL Server varchar(8000) being truncated to char(255)

In one of my tables, I have four fields that are all varchar(8000) -- not
that I ever need that much text, but I never know with our customer service
department.  Well, I created one report, that seems intent on truncating
these fields to 255 characters.  In VB, I can see all the text entered (on
average, about 500 to 1,000 characters) in all my RichText boxes.  But for
some reason or other, the problem comes into play once I start using SCR7.
When I try to print the report from VB6 or from SCR7 itself, I get the same
results.  What's up with the text truncation?  Does it just not like the
varchar datatype?

Thank you kindly...

Seth Anderson

Mon, 25 Mar 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Crystal Truncates My VarChar to 255 Chars

2. Data in varchar(2000) field truncated at 255 characters on report

3. Crystal Reports 8.5 Truncates Varchar fields larger then 255 characters

4. Crystal VARCHAR(255) limit with SQL Server

5. Truncated Varchar(600) field to 255 Characters

6. Custom Document Property value truncated at 255 chars

7. odbc truncates at 255 chars

8. Format truncates text to 255 chars?

9. Format() truncates strings to 255 chars?

10. Varchar 8000

11. Char vs VarChar in SQL Server

12. SQL Strings appear to truncate to 255 characters


Powered by phpBB® Forum Software