I've never used bit data type and can only guess. Would it be possible
that bit 0 was converted to {.a. and stripped off as termination byte
for c strings? Did it work if bits returned are all 1's?
Втр, 15 Июн 2010, Cox, Ed писал(а):
> I’m finding that bit data types are not being returned correctly via ODBC
> from SQL Server. I’ve tried two different drivers (Driver={SQL Server} and
> Driver={SQL Native Client}). If I run a query that should return 20 rows of
> just a single bit field and unbox it the shape is 1 20 0, which looks like
> the 1 character data is somehow getting lost.
>
> I’ve tried to understand odbc.ijs but have only gotten so far. I’m better at
> writing my own code than understanding someone else’s. I’ve looked in the
> forum but did not see anything similar to this issue being discussed.
>
> Has anyone else run into this? I am using J602 on Windows XP.
>
> Ed Cox
> Principal Data Analyst
> [email protected]
>
>
> _________________________________________________
>
> This message is for the designated recipient only and may contain privileged,
> proprietary
> or otherwise private information. If you have received it in error, please
> notify the sender
> immediately and delete the original. Any other use of the email by you is
> prohibited.
>
> Dansk - Deutsch - Espanol - Francais - Italiano - Japanese - Nederlands -
> Norsk - Portuguese
> Svenska: www.cardinalhealth.com/legal/email
--
regards,
====================================================
GPG key 1024D/4434BAB3 2008-08-24
gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
