The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.
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
Active 3 days ago
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
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Creating and Managing Databases with phpMyAdmin in cPanel.
This article shows the steps required to install WordPress on Azure.
Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan.
WordPress is no exception and requires an App Service Plan and Database to install
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 Month10 days, 21 hours left to enroll
618 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.