[sqlite] sql select of varchar text with special chars

Hello all,   I've a table in oracle that contains fields of type varchar2. In these fields are TCL scripts that contain backslash chars and brackets.   Now, I've generated an SQL file from the Oracle table data that contains SQL insert statements. I then use sqlite .read to read in the entire

[sqlite] memory and db size

Hello all,   I'm working on a GUI application using Tcl/Tk with sqlite back end on windows. Now, multiple users will be running this and all users must have a copy of the db local to their PC or in a shared drive. At least that is my understanding of how sqlite works.   1. What are my options

[sqlite] extra character when reading SQL file

Hello,   I noticed that when I .read a SQL file with insert statements, sqlite is inserting an \r before the \n for multiline chars. So I had to regsub out the \r char. Is there a way to override this extra char?   I'm on Windows2k   Thank you

[sqlite] problem with sqlite storing TCL scripts

Hello all,   I've used sqlite3 .read command to read in an SQL file from (exported via TOAD) Oracle that contains TCL scripts.   The .read worked fine, but now I'm noticing that my multi-line scripts are not running properly on the shell when I retrieve them from the sqlite table.   I notice

[sqlite] problem reading in SQL file with To_Date from Oracle

Hello all,   I'm new to sqlite3. I have data in a Oracle table with one column being a date type. Now, I've exported this table into a sql file with insert statements.   Then, I ran the .read command in sqlite3 to read in the sql statements. sqlite doesn't support the TO_Date function.   How do

[sqlite] question on creating/populating table with varchar/clob data types

Hello all,   I have a TCL application that writes database records to an Oracle db. This database has grown to contain 8000 records. There are 2 columns of varchar with 4k chars and 1 column of clob which contains 1Mg max. The data in this database are scripts.   Now, I need to write another