Details for the issue

What did you do?

I have a database consisting largely of columns of numbers, though the columns do not have a defined type.
If I edit one of these numbers in DB4S 'Edit Database Cell', it shows exactly as it did before and the type and format description remain the same at Type: Text / Numeric; size 4 characters.

However, when I load the database into my Python app, the edited numbers load as string, where the original numbers load as float.

What did you expect to see?

If the database storage format has changed, I would expect to see some difference in the DG4S display, but I don't.

However, if I load the amended database in SQLiteStudio, this does show the original numbers are different from the edited numbers (left justified rather than right justified). It appears there is some format information in the database that is not recognised or updated by DB4S.

What did you see instead?

Is there any way of making DB4S update whatever format information has changed in the edited cell, and show what this is?

Useful extra information

DB4S v3.13.0 [built for x86_64-little_endian-llp64] on Windows 10 Version 2009 (winnt/10.0.19045) [x86_64]
using SQLite Version 3.46.0
and Qt 5.15.2