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.

bit field

2 posts in General Discussion Last posting was on 2003-11-25 12:08:06.0Z
Dmitri Shvetsov Posted on 2003-11-25 04:55:30.0Z
From: "Dmitri Shvetsov" <dshvetsov@cox.net>
Newsgroups: ianywhere.public.general
Subject: bit field
Lines: 8
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: ip68-108-210-73.ph.ph.cox.net
X-Original-NNTP-Posting-Host: ip68-108-210-73.ph.ph.cox.net
Message-ID: <3fc2e0c2$1@forums-1-dub>
Date: 24 Nov 2003 20:55:30 -0800
X-Trace: forums-1-dub 1069736130 68.108.210.73 (24 Nov 2003 20:55:30 -0800)
X-Original-Trace: 24 Nov 2003 20:55:30 -0800, ip68-108-210-73.ph.ph.cox.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2131
Article PK: 4345

Hi,

How a bit field should be saved in a database? As a bit, byte, or word? I'm
just wondering...

Dmitri


Breck Carter [TeamSybase] Posted on 2003-11-25 12:08:06.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: bit field
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <uqg6svomoh5r79etukns0hppdd5sd8f5t0@4ax.com>
References: <3fc2e0c2$1@forums-1-dub>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
X-Original-Trace: 25 Nov 2003 04:14:20 -0800, bcarter.sentex.ca
Lines: 30
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 25 Nov 2003 03:57:50 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 25 Nov 2003 04:08:06 -0800
X-Trace: forums-1-dub 1069762086 10.22.108.75 (25 Nov 2003 04:08:06 -0800)
X-Original-Trace: 25 Nov 2003 04:08:06 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2132
Article PK: 4347

From Chapter 1, Creating, in SQL Anywhere Studio 9 Developer's Guide
ISBN 1-55622-506-7 Wordware Publishing, due in 2004...

=====
The BIT data type is useful for boolean data where 0 represents FALSE
and 1 is TRUE. A full byte of physical storage is used for each value
but only the values 0 and 1 are allowed.

By default BIT columns are created as NOT NULL but can be explicitly
created as NULL. This differs from other data types where NULL is the
CREATE TABLE default and NOT NULL must be explicitly specified.
=====

Breck

On 24 Nov 2003 20:55:30 -0800, "Dmitri Shvetsov" <dshvetsov@cox.net>

wrote:

>Hi,
>
>How a bit field should be saved in a database? As a bit, byte, or word? I'm
>just wondering...
>
>Dmitri
>

--
bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com