-----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 [EMAIL PROTECTED] (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-----
