Seagate ST43401N/ND Informacje Techniczne Pobierz pdf (Strona 59)

Migrating to Sybase Adaptive Server Enterprise 11.5 5-5

Adaptive Server Enterprise 11.5 If Your Current Version is 4.x

Datatype Hierarchy

The datatype hierarchy determines the datatype of computational

results. The result value is assigned the datatype of its parent

component closest to the top of the hierarchy. There is no loss of

precision due to conversions. However, Adaptive Server may return

datatypes different than those returned by earlier versions of SQL

Server.

In release 4.x, the money datatype was higher than ﬂoat datatypes. For

ANSI compatibility, release 10.x moves money below the ﬂoat and

numeric datatypes. This will cause a ﬂoat value to be returned when

both these datatypes appear in a query.

Table 5-3 shows the current datatype hierarchy:

Table 5-3: Datatype hierarchy

Name Hierarchy

ﬂoatn 1

ﬂoat 2

datetimn 3

datetime 4

real 5

numericn 6

numeric 7

decimaln 8

decimal 9

moneyn 10

money 11

smallmoney 12

smalldatetime 13

intn 14

int 15

smallint 16

tinyint 17

bit 18

varchar 19

1 2 ... 54 55 56 57 58 59 60 61 62 63 64 ... 171 172

Brak uwag

Seagate ST43401N/ND Informacje Techniczne Strona 59