2009/3/27 Simon Davies <simon.james.dav...@googlemail.com>: > 2009/3/27 Francois Botha <igitur+sql...@gmail.com>: >> >> Uhm, sorry. I'm new here. I don't want to paste the SQL script in an email, >> because it contains line breaks and I don't want the formatting to change >> during email transport. >> >> Try www.vwd.co.za/sqlitedump.zip > > Confirm I get same result you are reporting. > > Don't believe it is sqlite issue tho. > > shell.c about line 704: > fprintf(p->out, "%s;\n", zSql); > > At this point zSql contains exactly the right characters. However, in > the file resulting from the printf, extra '0D' characters appear. > > Note that this only occurs with redirection on the command line. Using > ".output t.sql" at the sqlite shell prompt gives the result I would > expect. > > Maybe people more familiar with micros*t internals could explain... > >> >> regards, >> Francois > > Rgds, > Simon >
Forgot to mention: The extra '0D' characters appear where there are embeded newlines in the CREATE statements. Rgds, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users