MySQL Forums :: General :: First column data truncation

Advanced Search

First column data truncation
Posted by: Michael Cleary ()
Date: January 17, 2013 01:11PM

This is not a serious issue - just irritating...

From a command prompt (Windows 7), whenever I try to display all data in a table (select * from mytable), the data in the first column is always truncated. This happens regardless of column width or the number of characters in the data items.

Currently, my first column is an auto-incremented ID field ( type int(11) ) that begins with "1" and ends with "182". When I try to display the whole table, the first two characters of all of the numbers are removed (except for the very last row where "182" is displayed corrrectly). When I select just the first column everything is displayed correctly, so I know that all the data is there.

Anyway, its not a big deal, but if anyone knows what I'm missing I'd appreciate the enlightenment!

Options: ReplyQuote

Subject Written By Posted
First column data truncation Michael Cleary 01/17/2013 01:11PM
Re: First column data truncation laptop alias 01/18/2013 04:25AM
Re: First column data truncation Michael Cleary 01/22/2013 10:58AM
Re: First column data truncation Rick James 01/22/2013 11:18PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.