Data Truncated

Posted on 2003-02-28
Medium Priority
Last Modified: 2012-06-27
I am using a prog. built with powerbuilder and I keep getting an [ODBC][DATA TRUNCATED] error. Is there a way to get around this ?
Question by:Stratocaster
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

Accepted Solution

DaniPro earned 200 total points
ID: 8042087
That happened because the application have a datawindow with a text field with a dimension less of the same in the database.
When the field in the database store a value with a number of character greater of that in the datawindow, the application get the error "data truncated".
If you can't modify the application the only solution is find the field that generate the error and truncate the text of all row at the greatest dimension of the field in the datawindow

Author Comment

ID: 8042139
Thanks for the prompt response. I actually didn't build this program but our ISD dept is sometimes less than willing to help. Thanks Again Danipro.

Featured Post

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

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

The Summer 2017 Scholarship Winners have been announced!
This month, Experts Exchange’s free Course of the Month is focused on CompTIA IT Fundamentals.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
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…
Suggested Courses

800 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