Re: stopping numification

[prev] [thread] [next] [Date index for 2005/05/24]

On Tuesday 24 May 2005 11:06, Simon Wistow wrote:
> On Tue, May 24, 2005 at 10:55:07AM -0600, Gordon Haverland said:
> > So, what differentiates a string of '1' from an integer of
> > '1' from a float of '1.0'?
>
> I'm not entirely sure what you're getting at but the thing that
> differentiates them is that, err, they're different. Or at
> least, a string of '1.0' is different from a string of '1'.
>
> If anything, everything but the primary autoincrement key
> should be stored as a string then.

As I read the SQLite documentation, you could declare a column to 
be integer and store "1.9935678" in it, or another column could 
be declared char(1) and have a 4 byte integer stored in it.  Perl 
treats a string of '1', an integer 1 and a float of 1.0 
differently, but SQLite may not.

Gord