FreeTDS Development Group

[<manoranjan_sahu AT agilent.com>]

Hello,

   I am using unixODBC with freetds v0.63RC10.

 

The issue I have is that my application is truncating the real number data.

I was able to see this behavior through tsql as well. Here is the test case.

 

create table t1 (c1 integer, c2 real)

go

delete from t1

go

insert into t1 values(1, 123456789.123456789)

insert into t1 values(2, 12345678.123456789)

insert into t1 values(3, 1234567.123456789)

insert into t1 values(4, 123456.123456789)

insert into t1 values(5, 12345.123456789)

go

 

>From tsql, we get the following results.

 

1> select c1, c2 from t1 order by c1

2> go

c1      c2

1       1.234568e+08

2       1.234568e+07

3       1234567

4       123456.1

5       12345.12

 

 

Please note that the actual data is truncated. 

 

Is there any config option to change this default behavior so that the 
results are not truncated?

 

Appreciate your help in this regard,

 

Thanks,

Manoranjan