List:MySQL on Win32« Previous MessageNext Message »
From:Jorge Bastos Date:October 7 2005 1:52pm
Subject:Fw: UPDATE does round value automatically - is it an error?
View as plain text  
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" <georg@stripped>
To: "Jorge Bastos" <mysql.jorge@stripped>
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@stripped]
Gesendet: Freitag, 7. Oktober 2005 14:57
An: win32@stripped
Betreff: Fw: UPDATE does round value automatically - is it an error?

show the table structure



----- Original Message ----- 
From: "Vassilopulos, Georg" <georg@stripped>
To: <win32@stripped>
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=1


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



Thread
Fw: UPDATE does round value automatically - is it an error?Jorge Bastos7 Oct