You probably have created your table without specifying the format of the double...
the following statement would be more appropriate to your expectation:
mysql> create table testTable (id int, val double(12, 9));
this will set the display width of the double to 12 and the number of digits following
the decimal point to 9.
You can ALTER the column definition to avoid re-entring the data..
-Nasser
---------- Philipp Sutter <[EMAIL PROTECTED]> writes:
Return-Path: <[EMAIL PROTECTED]>
Received: from mx05.lax.untd.com (mx05.lax.untd.com [10.130.24.65])
by maildeliver03.nyc.untd.com with SMTP id AAA9C4WJSAMUQ6QJ
for <[EMAIL PROTECTED]> (sender
<[EMAIL PROTECTED]>);
Tue, 21 Jan 2003 08:54:24 -0500 (EST)
Received: from web.mysql.com (web.mysql.com [213.136.49.183])
by mx05.lax.untd.com with SMTP id AAA9C4WJRAQCPDZJ
for <[EMAIL PROTECTED]> (sender
<[EMAIL PROTECTED]>);
Tue, 21 Jan 2003 05:54:23 -0800 (PST)
Received: (qmail 19865 invoked by uid 7797); 21 Jan 2003 13:36:40 -0000
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org)
List-ID: <mysql.mysql.com>
Precedence: bulk
List-Help: <mailto:[EMAIL PROTECTED]>
List-Unsubscribe: <mailto:[EMAIL PROTECTED]>
List-Post: <mailto:[EMAIL PROTECTED]>
List-Subscribe: <mailto:[EMAIL PROTECTED]>
Delivered-To: mailing list [EMAIL PROTECTED]
Received: (qmail 19846 invoked from network); 21 Jan 2003 13:36:40 -0000
Subject: mysql: field type of double without scientific notation
From: Philipp Sutter <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
In-Reply-To: <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Ximian Evolution 1.0.8
Date: 21 Jan 2003 16:40:53 +0100
Message-Id: <1043163653.3899.7.camel@sutter>
Mime-Version: 1.0
I have a Mysql-table with a field of type double. when i retrieve very small
numbers from this table I get them allways in a scientific notation:
i.e. 8.34e-05. what i have to do, that i get the same number in normal
notation: 0.0000834?
thank you for any hints in advance!
philipp
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
