On 3/19/08, Derek Developer <[EMAIL PROTECTED]> wrote:
> In SQLite a NUL is nothing. Inserting a NUL into a column defined as Integer
> for example creates a zero length entry not an Integer of value zero.
>
> How do traditional databases with static typing deal with this?
Probably all
"Derek Developer"
<[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> In SQLite a NUL is nothing. Inserting a NUL into a column defined as
> Integer for example creates a zero length entry not an Integer of
> value zero.
>
> How do traditional databases with static typing deal with this?
> How does SQLite handle sorting with a column that contains values
> (including zero) and NULs? Are the NULs converted to zero for the
> purposes of sorting?
A null value is considered less than all other values when sorting.
http://www.sqlite.org/datatype3.html#comparisons
Dan.
In SQLite a NUL is nothing. Inserting a NUL into a column defined as Integer
for example creates a zero length entry not an Integer of value zero.
How do traditional databases with static typing deal with this?
Do they check the column delaration and convert the NUL to a zero value upon
entry?
4 matches
Mail list logo
