The following table shows Datatype Conversion properties and associated global variables and set statements.
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} |
Copyright © 2005. Sybase Inc. All rights reserved. |