Sybase 7.5 manual Numeric data types, Character data types, 126

Models: 7.5

1 288
Download 288 pages 28.98 Kb
Page 136
Image 136

Defining domains

Numeric data types

Conceptual data type

Integer

Short Integer

Long Integer

Byte

Number

Decimal

Float

Short Float

Long Float

Money

Serial

Boolean

What it stores

32-bit integer

16-bit integer

32-bit integer

256 values

Numbers with a fixed decimal point

Numbers with a fixed decimal point

32-bit floating decimal numbers

Less than 32-bit floating decimal number

64-bit floating decimal numbers

Numbers with a fixed decimal point

Automatically incremented numbers

Two opposing values (true/false; yes/no; 1/0)

Length?

Fixed

Fixed

Fixed

Fixed

Fixed

Precision?

·

·

Character data types

Conceptual data type

Characters

Variable Characters

Long Characters

Long Var Characters

Text

Multibyte

Variable Multibyte

What it stores

Character strings

Character strings

Character strings

Character strings

Character strings

Multibyte character strings

Multibyte character strings

Length?

Fixed

Maximum

Maximum

Maximum

Maximum

Fixed

Maximum

126

Page 136
Image 136
Sybase 7.5 manual Numeric data types, Character data types, 126