Click here to Skip to main content
Click here to Skip to main content

MySQL throws Data trucanted for column 'colum name' at row n...

, 17 Mar 2012 CPOL
Rate this:
Please Sign up or sign in to vote.
Is not an error. Is an alert because MySQL rounded or trim the data you want to update

Some times we confuse an alert with an error.

The text "Data trucanted for column 'colum name' at row n..." indicates that the data you want to set to update a column has more decimals than the expected or in the case of string is longer thant the expected.

 No error happened. But You should to check after update if the data stored is your desired values. 

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Alberto León
Technical Lead Get Me An Apartment
Spain Spain
I'm developer fall in love with C#, .NET and Mono.
Designing and programming websites since 2001.
I like literature (to read and to write), playing football (soccer)... and of course I'm great fan of La Roja (Spain football team)
 
At now I work in GetMeAnApartment, I do Research and Development features to upgrade our website (asp.net, MVC, MySQL) and business model (rental short stay apartments)
 

My Knowledge:
LANGUAGES: C#, XML, HTML, JavaScript, ActionScript, php, VisualBasic Script
 
TECHNOLOGIES: asp.net, asp.net mvc, php, flash, GTK#
 
APPLICATIONS: wordpress, wikimedia, I programmed modules for Macromedia Flash MX for myself
 
FRAMEWORKS: .Net Framework, Mono
 
SERVERS: IIS, apache2
 
SO: Windows, Debian
 
SOFTWARE: Visual Studio 2010, 2008. Monodevelop. Glade. Illustrator. Indesign. Photoshop. Dreamweaver.
 

Employment:
 
GetMeAnApartment
IT Director and website developer, 2010 - present
 
Círculo Rojo Publicidad y Comunicación
IT Director and websites developer, 2007 - 2010
 
Dédalo Creative
Co-founder,Programmer and Developer, Graphical designer 2006 - 2007
 
Costa Mediterránea Comunicación
Chief writer, 2004 - 2006
 
Stalker Creacion
Web designer and developer, 2001 - 2003
 
Education
Myself
Designer and Programmer, 2001 - present
 
Jaime I, University
Advertising, 2000 - 2005
Follow on   Twitter

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Mobile
RA-Web1 | 2.8.141022.2 | Last Updated 17 Mar 2012
Article Copyright 2012 by Alberto León
Everything else Copyright © RootAdmin, 1999-2014
Terms of Service
Layout: fixed | fluid