Re: [sqlite] determining storage type

[Dennis Cote]

Hua-Ying Ling wrote:
How do you tell what the storage type of a field is?  If a field returns
1234, how can you tell if it is stored as an integer or text?
  
If you  are using the command line shell the typeof() function will 
return the type.

select field, typeof(field) from a_tabe;

HTH
Dennis Cote



-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------