Datatype Conversion properties

Table 3-5 shows Datatype Conversion properties and associated global variables and set statements.

Table 3-5: Datatype Conversion properties

Configuration property

Global variable and set statement

BinaryResults

select @@BinaryResults

set BinaryResults {binary | char}

DateResults

select @@DateResults

set DateResults {datetime | datetime4 | char_eur | char_iso | char_jis | char_usa}

DateTimeResults

select @@DateTimeResults

set DateTimeResults {datetime | datetime4 | char_eur | char_iso | char_jis | char_usa}

DecimalResults

select @@DecimalResults

set DecimalResults {autoconvert | char | int | real | float | money | money4 | bcd}

FloatResults

select @@FloatResults

set FloatResults {float | real | char}

GraphicResults

select @@GraphicResults

set GraphicResults {binary | char}

Int2Results

select @@Int2Results

set Int2Results {smallint | char}

Int4Results

select @@Int4Results

set Int4Results {int | char}

RealResults

select @@RealResults

set RealResults {float | real | char}

TimeResults

select @@TimeResults

set TimeResults {datetime | datetime4 | char_eur | char_iso | char_jis | char_usa}