Jump to content


Photo

A text field is not displaying all my data


  • Please log in to reply
3 replies to this topic

#1 bernie.nmsu

bernie.nmsu
  • Members
  • PipPip
  • Member
  • 22 posts

Posted 19 August 2004 - 10:29 PM

I have created a page which allows users to enter their bio information. Once the page is submitted, the bio information is stored correctly on the database. I then have another page which displays the bio to others, and I can not get it to display over 255 characters. The field is defined as a VARCHAR (2000) in the database.

I have attempted to change the display field from a regular text field to a text area and even just tried dropping the data in without a field format. My data still gets cut off but it remains in full on the database.

Is there a limit to the data that can be displayed in DreamWeaver MX?

Please let me know

#2 Arenium

Arenium
  • Staff Alumni
  • Advanced Member
  • 111 posts
  • LocationMassachusetts

Posted 19 August 2004 - 10:36 PM

Heh. Simple problem, simple solution. The maximum column length of a VARCHAR field is between 0 and 255. Read more about this and the CHAR types here. Basically, you'll want to change your column type to a BLOB or TEXT, whatever you see fit.

#3 bernie.nmsu

bernie.nmsu
  • Members
  • PipPip
  • Member
  • 22 posts

Posted 19 August 2004 - 10:48 PM

You were right, it was rather simple to just change it to a text field. Thanks for the help!!!

#4 bernie.nmsu

bernie.nmsu
  • Members
  • PipPip
  • Member
  • 22 posts

Posted 20 August 2004 - 07:11 PM

This is solved




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users