Skip to Content.
Sympa Menu

freetds - [freetds] Truncated data for real data type in Sybase.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: <manoranjan_sahu AT agilent.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Truncated data for real data type in Sybase.
  • Date: Tue, 22 Nov 2005 12:13:32 -0700

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





Archive powered by MHonArc 2.6.24.

Top of Page