On 27 Jun 2012, at 5:00pm, Maury Markowitz <[email protected]> wrote:
> I'm working on getting the Mac version of the SQLite ODCB connector fully
> functional. I'm having some problems getting examples of lots of different
> data types - for instance, my northwind copy has a decimal stored as a
> varchar.
Note that SQLite is somewhat weird in that you can declare a column as being of
one type, but then put another type of variable in it. Example below.
> Does anyone have a small test DB they would be willing to part with so I
> could see lots of different data types and what happens when they come
> through the adaptor?
Can I suggest you make up your own using the command-line shell ? Then you can
mess with it to your heart's content. cd to a folder you want your database
file in and use the commend-line shell supplied with OS X to create your own
database.
cd ~/Desktop
sqlite3 testdb.sqlite
CREATE TABLE testTable (textVar TEXT, intVar INTEGER, realVar REAL);
INSERT INTO testTable VALUES ('this is text', 1, 1);
INSERT INTO testTable VALUES (2.2, 'and this is text two', 2.2);
SELECT * FROM testTable;
.quit
You should find a copy of the shell tool as '/usr/bin/sqlite3' which should be
in your default path. Apart from the very important '.quit', lots of
documentation for it can be found at
<http://www.sqlite.org/sqlite.html>
If you need a more up-to-date version of the shell tool, perhaps because you
want to use FOREIGN KEYS, you can download a precompiled Mac version from the
SQLite download page.
Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
