Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Mapping to REAL = float  RSS feed

Nick Widelec
Ranch Hand
Posts: 226
Eclipse IDE Firefox Browser Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!