On 9/12/07, Stéphane Thiers <[EMAIL PROTECTED]> wrote: Somehow I missed replying earlier, sorry about that.
> The column which contains these numbers is > declared as REAL. This raises another question to > me: I thought that the numbers were stored as > strings, so why sqlite would try to transform these strings into double? By declaring the column as REAL, you provided a type affinity. That means sqlite will try to convert any provided input into REAL form (which is double), and only store the original type if that fails. If you don't declare a type for the column, then the value you input will stay in the same type you provided it in (i.e. string). ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
