Re: cast and numeric conversion

2005-08-16 Thread Philippe Poelvoorde
Scott Noyes wrote: I've got two columns, one is 'integer' (and store negative value), the other one 'tinyint unsigned' (only > 1 stored in it), when I multiply these columns, quantity with negative value does not show up. (I expect -50*10 to give : -500, but the field stay blank.) I've look a bit

Re: cast and numeric conversion

2005-08-16 Thread Scott Noyes
> I've got two columns, one is 'integer' (and store negative value), the > other one 'tinyint unsigned' (only > 1 stored in it), when I multiply > these columns, quantity with negative value does not show up. > (I expect -50*10 to give : -500, but the field stay blank.) > I've look a bit at the doc

cast and numeric conversion

2005-08-16 Thread Philippe Poelvoorde
Hi, I've got two columns, one is 'integer' (and store negative value), the other one 'tinyint unsigned' (only > 1 stored in it), when I multiply these columns, quantity with negative value does not show up. (I expect -50*10 to give : -500, but the field stay blank.) I've look a bit at the docu