bernie.nmsu Posted August 19, 2004 Share Posted August 19, 2004 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 Quote Link to comment https://forums.phpfreaks.com/topic/1928-a-text-field-is-not-displaying-all-my-data/ Share on other sites More sharing options...
Arenium Posted August 19, 2004 Share Posted August 19, 2004 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. Quote Link to comment https://forums.phpfreaks.com/topic/1928-a-text-field-is-not-displaying-all-my-data/#findComment-6276 Share on other sites More sharing options...
bernie.nmsu Posted August 19, 2004 Author Share Posted August 19, 2004 You were right, it was rather simple to just change it to a text field. Thanks for the help!!! Quote Link to comment https://forums.phpfreaks.com/topic/1928-a-text-field-is-not-displaying-all-my-data/#findComment-6277 Share on other sites More sharing options...
bernie.nmsu Posted August 20, 2004 Author Share Posted August 20, 2004 This is solved Quote Link to comment https://forums.phpfreaks.com/topic/1928-a-text-field-is-not-displaying-all-my-data/#findComment-6278 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.