Re: [sqlite] Sqlite3 Affinity

2013-07-02 Thread RSmith
Please forgive my atrocious typo's - I never use a spellchecker for reasons of personal linguistic pride, which tend to bite me when replying in a hurry. Also, howcome no matter how much I force plaintext format on all mails, it returns as HTML? Does the mailing list have a format specifier

Re: [sqlite] Sqlite3 Affinity

2013-07-02 Thread RSmith
1 - Using SQL there exists an SQLIte function typeof(x) where x can be a column name and it will return the type which is specific to the affinity and not to the original specified type when creating the table. If on the other hand you simply wish to know which type supports which affinity, this

Re: [sqlite] Sqlite3 Affinity

2013-07-02 Thread Hick Gunter
rst rule takes precedence and so the column affinity will be INTEGER. -Ursprüngliche Nachricht- Von: techi eth [mailto:techi...@gmail.com] Gesendet: Dienstag, 02. Juli 2013 13:16 An: sqlite-users@sqlite.org Betreff: [sqlite] Sqlite3 Affinity Few Query : 1) Is their any function or Method to

[sqlite] Sqlite3 Affinity

2013-07-02 Thread techi eth
Few Query : 1) Is their any function or Method to get Affinity type associated with colum. 2) I understand Integer,Text & Float could satisfy all data type requirement.In that case where i can use blob Or Numeric type. Cheers - Techi ___ sqlite-users