solidDB Help : Programming : solidDB SA : Special notes about solidDB SA
  
Special notes about solidDB SA
You should be aware of the following important information and restrictions when you use solidDB SA.
solidDB SA and Binary Large Objects (BLOBs)
Currently, solidDB SA does not support BLOB streams and the maximum size of an attribute value is limited to 32K.
SaCursorColxxx functions and solidDB SQL supported datatypes
The SaCursorColXXX functions bind a variable of type XXX to a specified column. For example, the SaCursorColInt function binds a variable of type int to a specified column. When you bind a variable to a column, the variable and column usually have corresponding types; for example, you usually bind an int C variable to an INT SQL column. However, it is not absolutely required that the data type of the column and the data type of the bound variable be equivalent. For example, you could bind a C int variable to an SQL FLOAT, but you would risk losing precision (or even overflowing or underflowing) as data was transferred back and forth.
The SaCursorColXXX functions support the SQL datatypes listed in the following table:
 
SaCursorColxxx function
T
I
N
Y
I
N
T
S
M
A
L
L
I
N
T
I
N
T
E
G
E
R
R
E
A
L
F
L
O
A
T
D
O
U
B
L
E
D
E
C
I
M
A
L
N
U
M
E
R
I
C
C
H
A
R
V
A
R
C
H
A
R
L
O
N
G
V
A
R
C
H
A
R
W
C
H
A
R
W
V
A
R
C
H
A
R
L
O
N
G
W
V
A
R
C
B
I
N
A
R
Y
V
A
R
B
I
N
A
R
Y
R
L
O
N
G
V
A
R
B
I
N
A
R
Y
D
A
T
E
T
I
M
E
T
I
M
E
S
T
A
M
P
SaCursorColInt
X
X
X
X
X
X
X
X
X
X
X
X
X
X
 
 
 
 
 
 
SaCursorColLong
X
X
X
X
X
X
X
X
X
X
X
X
X
X
 
 
 
 
 
 
SaCursorColFloat
X
X
X
X
X
X
X
X
X
X
X
X
X
X
 
 
 
 
 
 
SaCursorColDouble
X
X
X
X
X
X
X
X
X
X
X
X
X
X
 
 
 
 
 
 
SaCursorColStr
 
 
 
 
 
 
 
 
X
X
X
 
 
 
 
 
 
 
 
 
SaCursorColDate
 
 
 
 
 
 
 
 
X
X
X
X
X
X
 
 
 
X
 
X
SaCursorColTime
 
 
 
 
 
 
 
 
X
X
X
X
X
X
 
 
 
 
X
X
SaCursorColTimestamp
 
 
 
 
 
 
 
 
X
X
X
X
X
X
 
 
 
 
X
X
SaCursorColData
 
 
 
 
 
 
 
 
 
 
 
 
 
 
X
X
X
 
 
 
SaCursorColDynData
 
X
X
X
X
X
X
X
X
X
X
 
 
 
X
X
X
 
 
 
SaCursorColFixStr
 
X
X
X
X
X
X
X
X
X
X
 
 
 
X
X
X
X
X
X
SaCursolColDynStr
X
X
X
X
X
X
X
X
X
X
X
X
X
X
 
 
 
 
 
 
Keep in mind that, as with other APIs, the success of some conversions in solidDB SA depend on declared values. For example, SaCursorCollInt is only able to handle the SQL datatype CHAR (as in "foo") if the actual value of the field is an integer (as in "123").
Go up to
solidDB SA