Click here to Skip to main content
969 members (162 online)
Click here to Skip to main content
Add your own
alternative version


Posted 17 Mar 2012

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

, 17 Mar 2012
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. 


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


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 (, MVC, MySQL) and business model (rental short stay apartments)

My Knowledge:
LANGUAGES: C#, XML, HTML, JavaScript, ActionScript, php, VisualBasic Script

TECHNOLOGIES:, 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.


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

Designer and Programmer, 2001 - present

Jaime I, University
Advertising, 2000 - 2005

You may also be interested in...

Comments and Discussions

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