?
Solved

field length and truncated data

Posted on 2008-10-05
3
Medium Priority
?
433 Views
Last Modified: 2013-11-05
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
Comment
Question by:seanpowell
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 8

Accepted Solution

by:
Leo Eikelman earned 2000 total points
ID: 22644585
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
 
LVL 31

Author Comment

by:seanpowell
ID: 22649016
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
 
LVL 31

Author Comment

by:seanpowell
ID: 22649467
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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL several years ago, it seemed like now was a good time to update it for object-oriented PHP.  This article does that, replacing as much as possible the pr…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question