View Full Version : SQL Database Length

02-20-2007, 05:27 AM
I've created an SQL DB which includes a COMMENT column, I then connect to the DB and show the results of that column on my webpage using <%=oRs.Fields("comment")%>, however the COMMENT info is not fully showing and gets cut off (see example.gif), in fact the SQL DB is not saving the entire comment entry (see example2.gif).

Can someone please help me out with this, why is this happening?


02-21-2007, 04:11 AM
I am not sure if I am barking up the right tree, but either:
the web form
the SQL statement
is truncating the text.

Check this by trying a regular select statement and see if the field is truncated. Some newer SQL DB haev implemented a type of BLOB statement to pick up large text and binary data.

If it is a mssqlserver database you can try the TEXT fieldtype, it should give plenty of space