Re: problem with decimal part

mark addison wrote: On Fri, 2006-08-11 at 10:30 +0100, Jorge Martins wrote: Hi, I have a client that want's to store in a table the exact number that he get's from a file, i've used a DOUBLE data type (MySQL 3.2x), but I have the following problem: If the number is for example 9.0 mysql

Re: problem with decimal part

On Fri, 2006-08-11 at 10:30 +0100, Jorge Martins wrote: > Hi, > > I have a client that want's to store in a table the exact number that he > get's from a file, i've used a DOUBLE data type (MySQL 3.2x), but I have > the following problem: > > If the number is for example 9.0 mysql truncates and

Re: problem with decimal part

Unfortunately i think you ought to use a varchar string, i read from the mysql manual and do not found a numeric type that can have different decimals number on each register. "Jorge Martins" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > Hi, > > I have a client that want's t

problem with decimal part

Hi, I have a client that want's to store in a table the exact number that he get's from a file, i've used a DOUBLE data type (MySQL 3.2x), but I have the following problem: If the number is for example 9.0 mysql truncates and only stores 9 I tried to use the (M,D) for example as (6,5) but th