Only columns with variable-length datatypes can store null values. When you create a NULL column with a fixed-length datatype, the SAP ASE server automatically converts it to the corresponding variable-length datatype. The SAP ASE server does not inform the user of the datatype change.
This table lists the fixed- and variable-length datatypes to which they are converted. Certain variable-length datatypes, such as moneyn, are reserved datatypes; you cannot use them to create columns, variables, or parameters:
|
Original Fixed-Length Datatype |
Converted to |
|---|---|
|
char |
varchar |
|
unichar |
univarchar |
|
nchar |
nvarchar |
|
binary |
varbinary |
|
datetime |
datetimn |
|
date |
daten |
|
time |
timen |
|
float |
floatn |
|
bigint, int, smallint, and tinyint |
intn |
|
unsigned bigint, unsigned int, and unsigned smallint |
uintn |
|
decimal |
decimaln |
|
numeric |
numericn |
|
money and smallmoney |
moneyn |