Am 15.4.06 um 02:36 schrieb Paul Nash:
I have taken the plunge and am converting from ver 2.8.16 to ver 3.
I used the .DUMP method but found a problem. My char/text fields
containg numbers were output as pure numbers without the quotes, so
that on input to ver 3 they were stored as integer rather than
string. This is a kind of bug in .DUMP. Maintaining the textedness
of values in columns with text affinity in ver 2 would ease the
move to ver 3.
Hmmh - it's unlikely that existing installations of sqlite2 would
change their behavior ;-)
Anway, you can always create your own 'dump' tool that would dump the
database as text only values - just use a slightly modified version
of the dump function that comes with the sqlite sources and quote
every value...
</jum>
