Supported data types

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Supported data types

Firman Wandayandi
Can anyone describe me, more detail list of which are data types
currently supported by SQLite, on both
http://sqlite.org/datatypes.html & http://sqlite.org/datatype3.html
had gave me some or maybe all (not sure), because when I create a
table with a SMALLINT column, seems SQLite is ok. So I figured out
there are more data types supported? please give me a list of it.

Regards,
--
Firman Wandayandi
Never Dreamt Before (http://php.hm/~firman/)
Reply | Threaded
Open this post in threaded view
|

Re: Supported data types

Lapo Luchini
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Firman Wandayandi wrote:

> Can anyone describe me, more detail list of which are data types
> currently supported by SQLite, on both
> http://sqlite.org/datatypes.html & http://sqlite.org/datatype3.html
> had gave me some or maybe all (not sure), because when I create a
> table with a SMALLINT column, seems SQLite is ok. So I figured out
> there are more data types supported? please give me a list of it.

As stated on those very pages, sqlite2 doesn't really care about data
types, only uses them in sorting (numbers are sorted differently than
strings).
This means, you can create a "b TINYINT" field and put the value
'hello world' in it (see the page itself for a more long explanation).

sqlite3 does have "stronger" data types, but are connected to the
specific value, not to the column anyway (but the column does have
"affinity", so that an integer put in a TEXT column gets converted to
text).
INT, SMALLINT or ANYTHINGINT will be INTEGER value anyway.
See paragraph "2.1 Determination Of Column Affinity" for more info.

- --
Lapo Luchini
[hidden email] (OpenPGP & X.509)
www.lapo.it (ICQ UIN: 529796)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (Cygwin)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iQIcBAEBAgAGBQJDN9R0AAoJELBiMTth2oCD0ywP/iJeBIk9abG8PEauMr1RqwKP
LUQWWJ/XFj3e/gmkQgGlKOxXV5i3trqQEVPZXUFnCmJl48T60IneuIvFNJKsxVli
cKGGutbWVpJrETcwhI0H6YLhp4CZrE9mlBtfIAasF+LUq1T4SIjxV4Nh4RWJUcn9
/ZJnY4MndKCZJ6TF7Y+RaHBswt9EkXlauWDXiYXaw2hmOsgzK7jn4VjJFhPdqqEx
gLZp0vSM0mSscVY3wQYpo4QmSL1rKsQk/M0ETmTcXBdxLRQ2VQztkug93f5zVdPO
lKCYDpVq/pjWfig+ManFUlwJobhuDcUntlm/yDE4wIWwOSf4kEWjyXapsVg5Yvyo
Kk3aFku3eSPrtqUgpTCu+kGxWp13pkTFa/B2VjdHf/bjJRcVIP1cyF8H1petjjpS
XV+xeQqCfXkpEI3BtOKUIMpMftIhX7rIZThL03Il0jY2XF9L6NE9lfHlRRcSu1MJ
zh8lKNPrFddN0b8uB0xEGBcjDsjwu9vJpJN5kbgGSxHYvHy5Fl70SA52E714w1H/
J76oy/06GUFqVVp6q4WFkhfhqHNI1SmWr4xiw+9G0E4XkmjkMtWQApiWHOo8tQXI
StQtDNPwvGDSzZqhuyU71F/g1KWBEQXT9eqzdi6/2M+40dArFEWvCEfcl9gT83YX
U4GsWJGx6NYlHYELuv+c
=wBvP
-----END PGP SIGNATURE-----