Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Reversed and Truncated value

2 posts in Windows NT Last posting was on 2000-09-25 19:59:28.0Z
Adam Mutch Posted on 2000-09-25 16:12:47.0Z
From: "Adam Mutch" <mutcha@spielo.ca>
Subject: Reversed and Truncated value
Date: Mon, 25 Sep 2000 13:12:47 -0300
Lines: 10
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <oGngFzwJAHA.201@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 198.164.10.80
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1610
Article PK: 1089085

When I insert into the database the value inserted is converted from a
64-bit integer to a binary(8). This works fine except that the value stored
is in reverse and when the value is received from the database it is
truncated to a 32-bit value instead of 64-bit......any help would be
appreciated...


Thanks


Bret Halford Posted on 2000-09-25 19:59:28.0Z
Message-ID: <39CFAEA0.E9E671E6@sybase.com>
Date: Mon, 25 Sep 2000 13:59:28 -0600
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en,ja
MIME-Version: 1.0
Subject: Re: Reversed and Truncated value
References: <oGngFzwJAHA.201@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 15
NNTP-Posting-Host: bret-pc.sybase.com 157.133.80.211
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1609
Article PK: 1089083

Hi Adam,

How are you inserting the values? Is this from an OpenClient/C program?
SybPerl?
Something else? Are you doing an explict convert?

Some example sourcecode would probably go a long way.

-bret

Adam Mutch wrote:

> When I insert into the database the value inserted is converted from a
> 64-bit integer to a binary(8). This works fine except that the value stored
> is in reverse and when the value is received from the database it is
> truncated to a 32-bit value instead of 64-bit......any help would be
> appreciated...
>
> Thanks