SQLite error
no such column: True
更正來源︰http://chriscraig.net/blog/sqlite-boolean-true-or-false/
INSERT INTO myTable (boolField) VALUES(true); (Failed)
INSERT INTO myTable (boolField) VALUES('true'); (Successed)
INSERT INTO myTable (boolField) VALUES(true); (Failed)
INSERT INTO myTable (boolField) VALUES('true'); (Successed)
| IDL Type | C++ | Visual Basic | Java |
| signed char | signed char |
| byte |
| unsigned char | unsigned char | Byte |
|
| wchar_t | wchar_t | Integer | char |
| signed short | short | Integer | short |
| unsigned short | unsigned short |
|
|
| signed int | int | Long | int |
| unsigned int | unsigned int |
|
|
| signed hyper | __int64 |
| long |
| float | float | Single | float |
| double | double | Double | double |
| BSTR | BSTR | String | java.lang.String |
| boolean | bool | Boolean | boolean |
| VARIANT | VARIANT | Variant | com.ms.com.Variant |
| DATE | DATE | Date | double |
| CY | CY | Currency | long |
| SAFEARRAY | SAFEARRAY | [] (a standard Visual Basic array) | com.ms.com.SafeArray |
| IUnknown* | IUnknown* | IUnknown | com.ms.com.IUnknown |
| IDispatch* | IDispatch* | Object | java.lang.Objec |