SQLite Forum

You can force the ".dump" command of sqlite version 2 to output only
string literals and not numeric literals using the following patch
to the "shell.c" file:

~~~~~
Index: src/shell.c
==================================================================
--- src/shell.c
+++ src/shell.c
@@ -385,22 +385,24 @@
       fprintf(p->out,"</TR>\n");
       break;
     }
     case MODE_Insert: {
       if( azArg==0 ) break;
       fprintf(p->out,"INSERT INTO %s VALUES(",p->zDestTable);
       for(i=0; i<nArg; i++){
         char *zSep = i>0 ? ",": "";
         if( azArg[i]==0 ){
           fprintf(p->out,"%sNULL",zSep);
+#if 0
         }else if( sqliteIsNumber(azArg[i]) ){
           fprintf(p->out,"%s%s",zSep, azArg[i]);
+#endif
         }else{
           if( zSep[0] ) fprintf(p->out,"%s",zSep);
           output_quoted_string(p->out, azArg[i]);
         }
       }
       fprintf(p->out,");\n");
       break;
     }
   }
   return 0;
~~~~~