[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 442
  • 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 EikelmanDirector, IT and Business DevelopmentCommented:
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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