Programmer Guide : solidDB® SA : Special notes about solidDB® SA
  
Special notes about solidDB® SA
This topic contains important information and restrictions about 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.
SaCursorCol* 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 SaCursorCol* functions support the SQL datatypes listed in the following table.
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
L
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
O
 
 
 
 
 
 
 
 
 
 
 
 
 
 
L
 
 
 
 
 
N
 
 
 
 
 
 
 
 
 
 
 
 
 
 
O
 
 
 
 
V
G
 
 
 
 
 
 
 
 
 
 
 
 
 
 
N
 
 
L
 
A
V
 
 
T
 
 
S
 
 
 
 
 
 
 
 
G
 
W
O
 
R
A
 
 
I
 
T
M
I
 
 
 
D
N
 
V
V
 
V
N
 
B
R
 
 
M
 
I
A
N
 
 
D
E
U
 
A
A
 
A
G
B
I
B
 
 
E
 
N
L
T
 
F
O
C
M
 
R
R
W
R
W
I
N
I
 
 
S
 
Y
L
E
R
L
U
I
E
C
C
C
C
C
V
N
A
N
D
T
T
 
I
I
G
E
O
B
M
R
H
H
H
H
H
A
A
R
A
A
I
A
SaCursolCol* function
N
N
E
A
A
L
A
I
A
A
A
A
A
R
R
Y
R
T
M
M
T
T
R
L
T
E
L
C
R
R
R
R
R
C
Y
R
Y
E
E
P
SaCursorColInt
X
X
X
X
X
X
X
X
X
X
X
X
X
X
 
 
 
 
 
 
SaCursor ColLong
X
X
X
X
X
X
X
X
X
X
X
X
X
X
 
 
 
 
 
 
SaCursor ColFloat
X
X
X
X
X
X
X
X
X
X
X
X
X
X
 
 
 
 
 
 
SaCursor ColDouble
X
X
X
X
X
X
X
X
X
X
X
X
X
X
 
 
 
 
 
 
SaCursorColStr
 
 
 
 
 
 
 
 
X
X
X
 
 
 
 
 
 
 
 
 
SaCursorCol Date
 
 
 
 
 
 
 
 
X
X
X
X
X
X
 
 
 
X
 
X
SaCursor ColTime
 
 
 
 
 
 
 
 
X
X
X
X
X
X
 
 
 
 
X
X
SaCursor ColTimestamp
 
 
 
 
 
 
 
 
X
X
X
X
X
X
 
 
 
 
X
X
SaCursor ColData
 
 
 
 
 
 
 
 
 
 
 
 
 
 
X
X
X
 
 
 
SaCursor ColDynData
 
X
X
X
X
X
X
X
X
X
X
 
 
 
X
X
X
 
 
 
SaCursor ColFixStr
 
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 in 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”).
See also
solidDB® SA