MySQL Forums
Forum List  »  Spanish

Re: Urgente, problema con campos "Float"
Posted by: William Chiquito
Date: February 06, 2007 03:57PM

Hola Carlos,

Me parece extraño tu caso.

Ejecuté el siguiente script y los resultados fueron los esperados:
select version();
Result:
version()           
--------------------
5.0.33-community-max

DROP TABLE IF EXISTS `t1`;

CREATE TABLE `t1` (
  `id` int(11) NOT NULL auto_increment,
  `valor` float(12,2) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;

insert into t1 (valor) values (157.51);
insert into t1 (valor) values (157.50);
insert into t1 (valor) values (157.56);
insert into t1 (valor) values (157.552);
insert into t1 (valor) values (157.596);

select * from t1;
Result:
    id  valor 
------  ------
     1  157.51
     2  157.50
     3  157.56
     4  157.55
     5  157.60

¿Qué otra información nos puedes dar para ver si detectamos el problema?



Edited 1 time(s). Last edit at 02/06/2007 03:58PM by William Chiquito.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Urgente, problema con campos "Float"
2673
February 06, 2007 03:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.