This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
In mysql when I do: describe table; I see in the field I previously declared as REAL the following description: float (4,2) unsigned
First of all it says (4,2) and when I try to put from java more than 2 digits like 100.3 it does not pass. maximum is 2 digits to the right of the decimal separator. so maximum I can set as a REAL 99.something.. However the description appearing from the command: DESCRIBE table; in mysql says clearly float (4,2) unsigned.
I noticed also unsigned and indeed I cannot put anything negative.. only positive numbers.. which contradicts the meaning of float in the java world.
I am wondering if it's only mysql which behaves in this way or all the databases? Thanks in advance.