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!
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.