[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 440
  • Last Modified:

field length and truncated data

Hi - I have a comment field on a webform, and I've set the db to the values as shown in the attached image.

The problem is a) I already had 1 response that went over the 1000 character limit, and b) everytime I export as an xls file through phpmyadmin, the data is being truncated even further down to 255.

So my question is, have I set up the db correctly on the server, and how do I export the data so I can view it all later in excel or access?

I realise that's 2 questions, but I assume they are related somehow to an incorrect setting on my part?

Thanks ;-)
sqlcode.gif
0
seanpowell
Asked:
seanpowell
  • 2
1 Solution
 
Leo EikelmanCommented:
You need to set the MAXLENGTH attribute in your webform for that text area to 1000.  This will limit the number of characters the user can put in.

I am not too sure about the export, I have never had this problem before.  You can use the following tutorial if you are still having problems:

http://www.tutorialized.com/view/tutorial/Export-MySQL-to-Excel/16570
0
 
seanpowellAuthor Commented:
Hi - I'm afraid the tutorial didn't help, I'll need to dig deeper to find out why excel is truncating the data at 255 characters.

Thanks.
0
 
seanpowellAuthor Commented:
Looking more closely the tutorial gets me in the direction where I need to go - I appreciate you help in posting the link ;-)
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now