Solved

field length and truncated data

Posted on 2008-10-05
3
402 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
  • 2
3 Comments
 
LVL 8

Accepted Solution

by:
Leo Eikelman earned 500 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Mysql not caching queries 4 64
MySQL Error 3 40
User with DBO permission can't remotely connect 15 45
PHP & MySQL - Rounding Results from a Select Query 3 14
Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

863 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now