Fw: UPDATE does round value automatically - is it an error?

Hum,

What kind of value are you inserting?

"10323.2"
or
"10323,2"

right now i cant find my documents about the mysql fields
but i think the "decimal" type is the one with more capability
you can use like

field_name decimal(12,2) not null

12 digits and 2 decimals


----- Original Message -----
From: "Vassilopulos, Georg"
To: "Jorge Bastos"
Sent: Friday, October 07, 2005 2:19 PM
Subject: AW: UPDATE does round value automatically - is it an error?


Table structure is here. Thank You!!

Field Type Null Key Default Extra
datum date (null) PRI 2004-00-00 (null)
closed_f tinyint(1) YES (null) 0 (null)
closed_s tinyint(1) YES (null) 0 (null)
umsatz_1_f float YES (null) 0 (null)
umsatz_2_f float YES (null) 0 (null)
umsatz_3_f float YES (null) 0 (null)
umsatz_4_f float YES (null) 0 (null)
umsatz_5_f float YES (null) 0 (null)
kasse_f float YES (null) 0 (null)
umsatz_1_s float YES (null) 0 (null)
umsatz_2_s float YES (null) 0 (null)
umsatz_3_s float YES (null) 0 (null)
umsatz_4_s float YES (null) 0 (null)
umsatz_5_s float YES (null) 0 (null)
kasse_s float YES (null) 0 (null)
differenz_f float YES (null) 0 (null)
differenz_s float YES (null) 0 (null)
safebag_f bigint(20) YES (null) 0 (null)
safebag_s bigint(20) YES (null) 0 (null)
ausgaben_f longtext YES (null) (null)
ausgaben_s longtext YES (null) (null)
wetter_f text YES (null) (null)
wetter_s text YES (null) (null)
timestamp_f timestamp YES (null) CURRENT_TIMESTAMP (null)
timestamp_s timestamp YES (null) 0000-00-00 00:00:00 (null)
benutzer_f varchar(30) YES (null) (null) (null)
benutzer_s varchar(30) YES (null) (null) (null)
ezk_f tinyint(1) YES (null) 0 (null)
ezk_s tinyint(1) YES (null) 0 (null)
custom_varchar_f varchar(30) YES (null) (null) (null)
custom_varchar_s varchar(30) YES (null) (null) (null)
custom_text_f longtext YES (null) (null)
custom_text_s longtext YES (null) (null)
custom_float_f float YES (null) 0 (null)
custom_float_s float YES (null) 0 (null)

-----Ursprüngliche Nachricht-----
Von: Jorge Bastos [mailto:mysql.jorge@decimal.pt]
Gesendet: Freitag, 7. Oktober 2005 14:57
An: win32@lists.mysql.com
Betreff: Fw: UPDATE does round value automatically - is it an error?

show the table structure



----- Original Message -----
From: "Vassilopulos, Georg"
To:
Sent: Friday, October 07, 2005 1:07 PM
Subject: UPDATE does round value automatically - is it an error?


Hello!



I use Mysql Server: 4.1.14-max on Windows Standard Server 2003



The Table is MyIsam and there is a Database field with Datatype float
called "kasse_s"

The value of this field is 10323.2

I want to UPDATE this field to 10323.22

After the update which goes without errors the field value is still
10323.2 and not as I would expect 10323.22



What mistake I am making?

How do I solve my problem?



Thank you for your help!



Sincerely

Georg








--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=georg@yormas.de


Nachricht wurde auf Viren geprüft!
AVG Anti-Virus System 7.0.344




--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org