[sqlite] Storing a INTEGER in a TEXT field

[Cecil Westerhof]

I have the following table:
CREATE  TABLE messages(
    messageID   INTEGER PRIMARY KEY AUTOINCREMENT,
    date        TEXT NOT NULL DEFAULT CURRENT_DATE,
    time        TEXT NOT NULL DEFAULT CURRENT_TIME,
    type        TEXT NOT NULL,
    message     TEXT NOT NULL
);

But for some data the field message is filled with an integer. An integer
takes less room as its text representation and it sorts differently also.
Is there a way to store an INTEGER in a TEXT field? Not very important,
more nice to have.

I just created the following view:
CREATE VIEW downloadCount AS
SELECT   date                     AS Date
,        time                     AS Time
,        CAST(message AS INTEGER) AS DownloadCount
FROM     messages
WHERE    type = 'download-count'
;

-- 
Cecil Westerhof
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users