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 only stores 9 > > I tried to use the (M,D) for example as (6,5) but the problem is that > mysql stores the number as 9.00000 and I don't want that, I want the > number to be the exact number I read from the file.
Technically 9, 9.0 and 9.00000 are exacatly the same _number_. > Is there any way to fix that? I thought of using a VARCHAR data type. > What do you think? Would be the way to go as what your after is the origional string value. Why do you need exactly the same string? MySQL is pretty good at auto casting so you can still treat the field as a number in most cases and see http://dev.mysql.com/doc/refman/4.1/en/cast-functions.html for functions to use in the other cases. mark > Thanks > > -- > Com os melhores cumprimentos > Jorge Martins - Wemake, Tecnologias de Informação, Lda. > Tel. 223744827 > MARK ADDISON WEB DEVELOPER 200 GRAY'S INN ROAD LONDON WC1X 8XZ UNITED KINGDOM T +44 (0)20 7430 4678 F E [EMAIL PROTECTED] WWW.ITN.CO.UK Please Note: Any views or opinions are solely those of the author and do not necessarily represent those of Independent Television News Limited unless specifically stated. This email and any files attached are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error, please notify [EMAIL PROTECTED] Please note that to ensure regulatory compliance and for the protection of our clients and business, we may monitor and read messages sent to and from our systems. Thank You. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
