On Wed, Feb 3, 2010 at 2:06 PM, Allin Cottrell
<cottrell@wfu.edu> wrote:
On Wed, 3 Feb 2010, Chris wrote:
> From reading the manual that bit was there because I am
> importing 2 columns, the first one being an identifier. When I
> remove the first column from my select statement I can import
> data from both my big query and my test query, but all the data
> shows up as "5.16957e-38" not the data that shows up when I run
> the same query in query analyzer.
* What does the identifier look like?
* 5.16957e-38 looks like one of the limits of a single-precision
"float". Gretl binds the last (data) column to SQL_C_DOUBLE.
But somehow we're getting the wrong data type? Perhaps the values
in this db are stored as SQL_REAL (which has a mantissa of
precision only 7). What's the database engine?