-
Notifications
You must be signed in to change notification settings - Fork 38
Mapping sqlite and objective c data types
ziminji edited this page Jul 24, 2011
·
3 revisions
Below is an alphabetized list of SQLite data types that are mapped to their Objective-C equivalents:
| SQLite Data Type | Objective-C Data Type |
| BIGINT | NSNumber |
| BINARY | NSData |
| BIT | NSNumber |
| BLOB | NSData |
| BOOL | NSNumber |
| BOOLEAN | NSNumber |
| CHAR | NSString |
| CHARACTER | NSString |
| CLOB | NSString |
| DATE | NSDate |
| DATETIME | NSDate |
| DECIMAL | NSDecimalNumber |
| DOUBLE | NSDecimalNumber |
| DOUBLE PRECISION | NSDecimalNumber |
| FLOAT | NSDecimalNumber |
| INT | NSNumber |
| INT2 | NSNumber |
| INT8 | NSNumber |
| INTEGER | NSNumber |
| MEDIUMINT | NSNumber |
| NATIONAL VARYING CHARACTER | NSString |
| NATIVE CHARACTER | NSString |
| NCHAR | NSString |
| NULL | NSNull |
| NUMERIC | NSDecimalNumber |
| NVARCHAR | NSString |
| REAL | NSDecimalNumber |
| SMALLINT | NSNumber |
| TEXT | NSString |
| TIMESTAMP | NSDate |
| TINYINT | NSNumber |
| VARBINARY | NSData |
| VARCHAR | NSString |
| VARIANT | NSString |
| VARYING CHARACTER | NSString |
Some data types may be preceded with the "UNSIGNED" modifier as in other SQL dialects. For more information on data types in SQLite, go to http://www.sqlite.org/datatype3.html.