Field Lenght Limitation in SQL 7 varchar field type 
Author Message
 Field Lenght Limitation in SQL 7 varchar field type
I have a field in one of my tables that is to store
comments.  I set the column as varchar(2000), but somehow
some comments that i'm storing which is 1500 characters
length won't stick...please help


Tue, 16 Mar 2004 01:12:23 GMT
 Field Lenght Limitation in SQL 7 varchar field type

How do you know the column is not storing all the data?
SELECT MAX(datalength(YourColumnGoesHere)) FROM YourTableGoesHere

How are you inserting data?
    stored procedures -- is the input param the right size?
    insert statements  -- are they correct?

Can you insert correct data via Query Analyzer?

--
Keith, SQL Server MVP
==============
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.


Quote:
> I have a field in one of my tables that is to store
> comments.  I set the column as varchar(2000), but somehow
> some comments that i'm storing which is 1500 characters
> length won't stick...please help



Tue, 16 Mar 2004 02:33:54 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. varchar(4000) field limitation

2. Varchar(8000) and Text field limitations

3. SQL 6.5 - text field to varchar(255) fields

4. To add a field of the type Dates with a field of the Whole type

5. Spaces padding / varchar field type...

6. Varchar or Text field type??

7. Varchar or Text field type??

8. RecordSet.Fields(x).Type for NUMERIC and VARCHAR datatype

9. URGENT:storing a string of 5000 characters into varchar field type

10. PRO COBOL WITH VARCHAR FIELD TYPE

11. A Varchar(1000) field vs 1000 Bit fields

12. Copying data from a TEXT field into two Varchar fields


 
Powered by phpBB® Forum Software