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
COURSE of the MONTH
9 days, 22 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
field length and truncated data
Posted on 2008-10-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
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
[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
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
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
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.
Thanks.
Featured Post
![[eBook] Windows Nano Server](https://filedb.experts-exchange.com/files/public/2017/6/24/1329f749-2f43-4bd1-8413-3b5b5ab33fc6.png)
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…
- Databases
- AWS
- MySQL Server
- MongoDB
- NoSQL Databases
- Percona
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
Course of the Month9 days, 22 hours left to enroll
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.