473,396 Members | 1,599 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

storing dbl_min in Oracle 9.2

I have problems on storing dbl_min into a "DOUBLE PRECISION" column in
Oracle 9.2 (via ODBC). dbl_min is 2.2250738585072014E-308 in case you
don't know.

The problem is Oracle rounds it to 0.0. Our application uses DBL_MIN as
the NaN for any doubel values, but 0.0 is a valid value to us.

I am asking for opinions on how to deal with this. The one workaround I
have is to store a special value instead, and when I retrieve it back I
convert this special value back to DBL_MIN. For example, I can use FLT_MIN
which is 1.17549435E-38F, or 2B.

Is this a sound approach? Any other suggestion? Thanks!!
- Will (jcwhui hotmail)
Jul 19 '05 #1
0 1317

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
by: Ryan Stewart | last post by:
I am in extremely urgent need (by tomorrow) of a way to store files in and retrieve files from an Oracle database using TopLink as an intermediary. I have the JSPs for it, and it works for small...
14
by: Ger | last post by:
Hi all. Atm i am writing special system to store and restore information. There were diffirent ideas how to do this, all have pluses and minuses. Finally we desided to write system, what is...
4
by: CJ Butcher | last post by:
Hi, I have a need to pull information from an Oracle 9.2.1 database. It is storing UTF-8 characters in a varchar2(33) field. I need to be able to pull these values out and put them in a SQL...
6
by: Mudcat | last post by:
Hi, I am trying to build a tool that analyzes stock data. Therefore I am going to download and store quite a vast amount of it. Just for a general number - assuming there are about 7000 listed...
13
by: mike_dba | last post by:
I am having some data reject on an insert of Japanese characters to a Varchar column in my DB2 UTF-8 database. I am trying to understand how big to make the Varchar column for the inesert to work...
2
by: janzon | last post by:
The output of the following program ---------------------------------------------------------- #include <iostream> #include <iomanip> #include <float.h> #include <fpu_control.h> #include...
0
by: jcwhui | last post by:
I have problems on storing dbl_min into a "DOUBLE PRECISION" column in Oracle 9.2 (via ODBC). dbl_min is 2.2250738585072014E-308 in case you don't know. The problem is Oracle rounds it to 0.0. ...
1
Parul Bagadia
by: Parul Bagadia | last post by:
Hello, For my project in Oracle, i need to store an images in 2 tables,... actually my front-end in the project is VB amd oracle is the back-end; so anybody has got the idea how do we store images...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.