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 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_.
Not if you have to count the number os significant digits.
I just think it's strange that in a DOUBLE(6,5) the number 9.0 stores
9.00000, I think that this should only happen if you choose ZEROFILL
option. 5 should be the max number of digits of the decimal part not the
mandatory number of digits...or maybe not, i'm not very good at math
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]
