From: Jorge Bastos Date: October 7 2005 1:52pm Subject: Fw: UPDATE does round value automatically - is it an error? List-Archive: http://lists.mysql.com/win32/17595 Message-Id: <016c01c5cb46$50992450$0301a8c0@hercules.decimalint.pt> MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 8bit 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@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" 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@stripped Nachricht wurde auf Viren geprüft! AVG Anti-Virus System 7.0.344