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

Reply via email to