SQLite: getting field information (type etc)
| From: | Robert S | Date: | Mon, 23 Feb 2004 08:54:06 +0000 |
| Subject: | SQLite: getting field information (type etc) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-178514@lists.php.net to get a copy of this message | ||
I am trying to port a small database application (php, MySQL) to sqlite.
How can I find the type of an arbitrary field? In other words, what is the
equivalent of mysql_field_type() and mysql_field_flags() in sqlite?
I read something on the sqlite group recently that recommended using
pragma_show_datatypes in a query, but I couldn't get this to work and the
example on the newsgroup was written in C.
Could somebody please enlighten me?